Re: can this be done with many to many relationship

On Wed, 04 Feb 2009 12:38:31 GMT, sparks <sparks@xxxxxxxxxxx> wrote:

You don't give enough information (for me) to determine if you have
the right structure. Why don't you describe the tables and their
relations in real-world terms rather than trying to be too abstract.

For example: We have customers, and each customer can have zero to
many orders. Each order can have one to many line items.

-Tom.
Microsoft Access MVP



We have a database that has one to many to many relationships.
one to many
autoid ID1 in the main table and number ID1 in the first multi record
subform/table

Then in the subsubforms that make up the many to many
I have ID2 to ID2.

ID1------ID1
............ID2-----ID2

I did this to keep the tables to a minimum.

I have been told that since the structure is like this
(names are for desc only)

tblmain--------tblsub1---------tblsubsub1

I only need ID1 and not a different ID2 on the many to many records.
ID1------ID1---------ID1

Can you do this having a sub of many to many records?


.

Relevant Pages
Loading