Ask Your Question

Revision history [back]

Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the relationships?

File upload: Many_to_Many_Concept.odb

The uploaded file is a simple example of 2 tables in a many to many relationship using an intermediate table. The Items table represents pieces of metal art. The Colors table represents paint colors that can be applied to the various Items. All colors are NOT applied to all Items. There is relevant data in all 3 tables. I've completed the Tools/Relationships chart accurately.

The goals:
1) When entering a new Item, be able to see and select the paint color(s) - by color name (not just the ID).
2) When adding a new Color, be able to see and select the Item(s) by Item Description (not just the ID).
3) Be able to modify any Item record adding or removing colors.

I suppose I'm no longer a newbie to LO base but I'm no expert either. Any advice would be greatly appreciated.

Thank you in advance!

Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the relationships?

File upload: Many_to_Many_Concept.odb

The uploaded file is a simple example of 2 tables in a many to many relationship using an intermediate table. The Items table represents pieces of metal art. The Colors table represents paint colors that can be applied to the various Items. All colors are NOT applied to all Items. There is relevant data in all 3 tables. I've completed the Tools/Relationships chart accurately.

The goals:
1) When entering a new Item, be able to see and select the paint color(s) - by color name (not just the ID).
2) When adding a new Color, be able to see and select the Item(s) by Item Description (not just the ID).
3) Be able to modify any Item record adding or removing colors.

I suppose I'm no longer a newbie to LO base but I'm no expert either. Any advice would be greatly appreciated.

Thank you in advance!

Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the relationships?data?

File upload: Many_to_Many_Concept.odb

The uploaded file is a simple example of 2 tables in a many to many relationship using an intermediate table. The Items table represents pieces of metal art. The Colors table represents paint colors that can be applied to the various Items. All colors are NOT applied to all Items. There is relevant data in all 3 tables. I've completed the Tools/Relationships chart accurately.

The goals:
1) When entering a new Item, be able to see and select the paint color(s) - by color name (not just the ID).
2) When adding a new Color, be able to see and select the Item(s) by Item Description (not just the ID).
3) Be able to modify any Item record adding or removing colors.

I suppose I'm no longer a newbie to LO base but I'm no expert either. Any advice would be greatly appreciated.

Thank you in advance!

Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data?data using forms?

File upload: Many_to_Many_Concept.odb

The uploaded file is a simple example of 2 tables in a many to many relationship using an intermediate table. The Items table represents pieces of metal art. The Colors table represents paint colors that can be applied to the various Items. All colors are NOT applied to all Items. There is relevant data in all 3 tables. I've completed the Tools/Relationships chart accurately.

The goals:
1) When entering a new Item, be able to see and select the paint color(s) - by color name (not just the ID).
2) When adding a new Color, be able to see and select the Item(s) by Item Description (not just the ID).
3) Be able to modify any Item record adding or removing colors.
4) When viewing Item records, have the color names displayed.

I suppose I'm no longer a newbie to LO base but I'm no expert either. Any advice would be greatly appreciated.

Thank you in advance!

Base n:m many to many relationships between two tables using intermediate table, how to enter, display & modify the data using forms?

File upload: Many_to_Many_Concept.odb

The uploaded file is a simple example of 2 tables in a many to many relationship using an intermediate table. The Items table represents pieces of metal art. The Colors table represents paint colors that can be applied to the various Items. All colors are NOT applied to all Items. There is relevant data in all 3 tables. I've completed the Tools/Relationships chart accurately.

The goals:
1) When entering a new Item, be able to see and select the paint color(s) - by color name (not just the ID).
2) When adding a new Color, be able to see and select the Item(s) by Item Description (not just the ID).
3) Be able to modify any Item record adding or removing colors.
4) When viewing Item records, have see the color names displayed.displayed on the form.

I suppose I'm no longer a newbie to LO base but I'm no expert either. Any advice would be greatly appreciated.

Thank you in advance!