Advanced Car Dealer Management Software. Dealer Gears is the best software for car dealers. It allows dealerships to simplify and speed up their sales processes and. Car Sales Database System dinesh yadav. Car Sales And Inventory Store Project - Duration. Used Car Dealer Software. Sales Database Software software free downloads and reviews at WinSite. Free Sales Database Software Shareware and Freeware. Car Dealer Organizer Pro: small car dealership database manager, software for windows, screens, tour.
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 the table has car info such as make model etc. The main table is customer info, it has customer ID as primary on autonumber, and also has stock number as a number on it, it also contains there name address etc. Medieval Total War 1 Crack Indir Fifa.
Last i have a payments table, it has the last date paid and next date due and amount. It has the Customer ID and the Stock ID in it.
I would like to have each car have a customer that is buying it, and then each customers has payments they are paying. But im not really sure how to tie it all together and make it work.
The main problem is, I have an inventory form, to easily fill out all the info, then i have a command button that opens customer info, but. My prob is that whenever i hit the customer info butotn to fill it out, it doesnt automatically relate the new customer to the current car i was viewing in the inventory form, so after i fill it all out it and close then reopen the customer info menu via the cmd button that it is all blank but the records stored, I guess i want a way to automactically make each new customer be related to the current car stock id open in the inventory form. Or is there a more effiecent way to setup my tables, but i still would like to have each car tied to a customer and payments tied to each customer. But with very functional forms. 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 want to tie it to joe jones, i can surely open the customer info table and change the stock id to 22, then all the forms show up right, but. Is there a way to automatically do this?
I have the relationship setup what i think should be correct, is there any way that access could be bugged? Or could someone give me a sample relationship setup that would work if mine is flawed? 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 automatically carrying the stock id from the current car i am viewing in my inventory, over to the stock id of the customer info form(and table), I open the customer info form via clicking a command button on the inventory form. (just to let you know) I hope this gives you a better idea of my situation.:) thanks for any help, this is about to kill me.
Heres a link to my database, please look it over and shoot me some ideas, or even mod it and upload your copy. Thanks alot!! RE: Used Car Inventory, customer, and payments database problems. DoomMarine44 First, have you read some of the following background info??
Fundamentals of Relational Database Design Micro$oft's answer.Moving on As I understand it, you want your Used cars database to. - track stock (cars, parts, both??) - customer - payments - ownership - automate some process I may suggest that you also track suppliers, especially if you are managing parts. I have run home and do the parent thing, but I will post back later some moreinfo. Richard RE: Used Car Inventory, customer, and payments database problems (TechnicalUser).
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 if i add the stock id to each customer manually and all the relationships work right then. Its just adding a new customer. It just doesnt carry from one form to another, like i would assume it should.
I don't really know about the parts, i just really need the cars customers and their payments setup in a working order. Thanks again for any help.! RE: Used Car Inventory, customer, and payments database problems (MIS) 24 Jan 05 17:32. DoomMarine44 Okay, I am back. This is what I came up with.