Setting up a query-able/modifiable one-to-many or none relationship

[TerraEarth]

I have two pieces of information that need to be linked in a one-to-many OR None type of relationship: Company info & Address info.

Take the following: {CompanyA: [Address_A1, Address_A2, Address_A_4], CompanyB: [], CompanyC: [Address_C1]}
In this data, companies can have 0, 1 or many addresses. Is this accomplishable in Access or is there perhaps another workaround for this type of data?

Additionally, i want to develop some functionality where users can query a specific Company (Say A) and check all the addresses listed under that company. If, for example, Address_A2 is a faulty address the user will then be able to correct/modify or perhaps even delete that Address so that it will be reflected as such in the DB. What I mean by this is, for every registered Address_A2 in the DB, it will be flipped to become Address_A4 (new).



How would you guys go about setting up for this?

[GinaWhipp]

I would use a Main Form\Subform. Main Form to look up Company and Subform to view addresses.

[isladogs]

If you want to show all companies including those with no address data, use a left join to link your two tables so it gets all records from the company table and any address data where it exists