Relationships problem

[cedricleo]

I have a table Firms_data(Firm_name, Address, Phone, Email, Fax, Financial_Data). Now, some firms can have more phone numbers, emails, fax numbers. I want to put these infos in separate tables, so i'll have the "phones" table, the "emails" and the "fax" one. How can i link the table Firms_data to the others. I found out that i can only link one field from the first table with only one table. how can i link the table with all the others?

[RuralGuy]

Your Firms_data table should have a PrimaryKey (PK) field. It would be nice if it was an AutoNumber field. Each of the other tables should have a ForeignKey (FK) field set to LongInteger if the PK of the 1st table is an AutoNumber. This field will contain the PK of the 1st table so you can maintain the 1:m relationship. Assuming you use a MainForm/SubForm to view/edit the data then Access will fill in the FK for you as you will have used the two fields as your LinkChild/MasterFields properties.

[cedricleo]

i won't use the access forms. i'll program an interface in Visual Basic.Net.
So far i made a PK, the field "CUI" (it is not an autonumber, so i'll have to update it with code). CUI will be FK i the other tables. Now, is there a possibility to see all the tables assigned to the first table when i press the + sign of a record in Datasheet view? Does Access show only one table at a time there, and i have to choose other table when i need it, from the insert menu?

[RuralGuy]

Your last sentence is more or less correct.