Hi everyone,
I cannot figure out how to link my tables. Here is my problem: I have one main table that contain informations about contracts (No folder, name of the provider, etc.) And I have 12 other tables. Each of them contains informations about one specific type of invoice. for exemple, one table is used for gaz billing, an other one is used for shipping, and so on. Now I don't know how to link all these tables with my main one. Because one entry in the main table have a 1-to-many relationship with all these tables. should I leave the relations, and just retreive information manually?
Here is the definition of the main table:
No - AutoNumber and primary key
Localisation - Text
...
The definition of the 12 tables is:
NoBill - AutoNumber and primary key
NoAutoInstallation - that contains the No from the main table
Total - total of the bill
I'm really confuse. Thanks in advance for your help!
I cannot figure out how to link my tables. Here is my problem: I have one main table that contain informations about contracts (No folder, name of the provider, etc.) And I have 12 other tables. Each of them contains informations about one specific type of invoice. for exemple, one table is used for gaz billing, an other one is used for shipping, and so on. Now I don't know how to link all these tables with my main one. Because one entry in the main table have a 1-to-many relationship with all these tables. should I leave the relations, and just retreive information manually?
Here is the definition of the main table:
No - AutoNumber and primary key
Localisation - Text
...
The definition of the 12 tables is:
NoBill - AutoNumber and primary key
NoAutoInstallation - that contains the No from the main table
Total - total of the bill
I'm really confuse. Thanks in advance for your help!