Access

[smileme]

Hello everone,
i wanted to ask you some questions about the design of database of car services.


How can i design a REA design ,i mean what fields are necessary and what relations can i write between them?
Which fields belongs to revenye cycle?
Thank you!

[jzwp11]

Welcome to the forum!

We are here to help, but you will have to provide some more details as to what type of information you are trying to capture in your database and a little more information about your business process.

I am guessing that you have customers (you'll need a table to hold basic customer data). I assume that a customer can have many vehicles (another table that relates to the customers). I assume that you perform multiple services (another table) on customer vehicles (another table that joins the vehicle to the services).