Search results for query: *

I have a problem with my database.. Seems simple but its a true pain, driving me into many emotional states. My main table is Inventory, then linked to customer info, then linked to payments..(this is a used car database) My main problem is automation. The main field in concern is...

Oh and not the forms part, I just need help with my stockID issue, or some way of setting up the relationships in an effcient manner, to allow for that one automated step, carrying the StockID over to the other form, upon creation of a new customer record, see my upper posts to see what I am...

Yes i havent thought about that to much PHV, I will have to re enter date, however that is non-important atm as I am just getting started, and and in dire need of a functional database that i can use to print out all the sale forms, ready to go. Any suggestions on how to make it functional?

I think my current setup will allow more than one car per customer, however I am new to access somewhat.. So I not 100% sure of this, if someone could check out my database i posted and, use the inventory form then click customer info and try to add a new record for that car.. you will see what...

I have read some on design, just alot of the realtionship stuff has been somewhat vague, I think i have a decent setup, just i can't get one tiny thing to work.. and its ultra annoying. It seems the way i have it setup the stock ID should carry over but it doesnt if i add a new record, it does...

Mr Abdulla, thanks for the help, I will look the database over, and did you use any programming or is this all done by point and click?? I have my data base uploaded http://home.alltel.net/deckofcars/carpricerforupload.mdb theres a link for it please look it over if you have time, and perhaps...

I am running a small used car lot doing buy here pay here, and im trying to setup a database accordingly.. but i cant quite get it going right.. heres an explanation of how i have it setup. I first have an inventory table with the stock ID being the primary key, it is auto numbered. the rest of...

on my relationships I have stock id in my main table inventory, tied to stock id in my 2nd table, customer info, then i have customer info in customer info tied to customer info in the payments table.. is this the way the relationships should be setup to do what i would like, which again is...

I have looked at many of those on that site already, and read most of those tutorials, but I still havent found a way to automatically carry the stock ID of the car I am viewing in on form, to the Stock ID in the customer info form, but lets say I have stock id 22 and its a nissan sentra, and i...

oops i forgot,the database is access. :) This problem is simple but its hard, it seems like it should work with just relationships.. but its not. :(

I am running a small used car lot doing buy here pay here, and im trying to setup a database accordingly.. but i cant quite get it going right.. heres an explanation of how i have it setup. I first have an inventory table with the stock ID being the primary key, it is auto numbered. the rest of...