|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 4th, 2007, 11:18 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Chain linked "1 to Many" relationships
I want to design my tables to have the following ER:
RMA Header---------------RMA Details------------Repair Details Each one of the 2 above ER will be "1 to Many". The tables will be tied to form/subform for both of the realthinships. The RMA details will be subform on one case and will a parent form in another.. Does Access 2003 supports this? Thx, Lysy 
|
|
#2
February 5th, 2007, 12:01 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Chain linked "1 to Many" relationships
yes. make sure you set the relationships up correctly in the Relationships
window, and enforce Referential Integrity. hth "Lysy404" wrote in message ... I want to design my tables to have the following ER: RMA Header---------------RMA Details------------Repair Details Each one of the 2 above ER will be "1 to Many". The tables will be tied to form/subform for both of the realthinships. The RMA details will be subform on one case and will a parent form in another.. Does Access 2003 supports this? Thx, Lysy
|
|
#3
February 5th, 2007, 12:08 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Chain linked "1 to Many" relationships
On Sun, 4 Feb 2007 15:18:00 -0800, Lysy404
wrote: I want to design my tables to have the following ER: RMA Header---------------RMA Details------------Repair Details Each one of the 2 above ER will be "1 to Many". The tables will be tied to form/subform for both of the realthinships. The RMA details will be subform on one case and will a parent form in another.. Does Access 2003 supports this? Thx, Lysy Yes; in fact (not that I'd ever want to!) you can nest subforms nine deep. There's nothing whatsoever wrong with having a form with two subforms, or separate forms both using the same table in different ways. John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
