Linking Mutiple Records to Single Records

[LukeJ Innov]

Basically I have a small issue which I am stuck on.



I have a database with a table with company names, then a relationship to another table that shows that companies' address, but I also want there to be an address 2 and 3 and so on, and some of our companies have multiple sites.

So what Im asking is how would you be able to show multiple data, on a sing record.Sorry if this is confusing.

[pbaldy]

Typically the address table would contain multiple records for a company with multiple addresses. You'd use a form with a subform to present the data to users.

[LukeJ Innov]

Thank you

[pbaldy]

No problemo.