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
|
|||
|
|||
subforms
So I have a Main form with 2 subtables. I made a 1 to many relationship
between F1 and F2.....F1 and F3. F2 and F3 are linked to F1 parent/Child with "ObID". Now when I go to the Table for F1, the subtable "+" sign no longer works to pull down the subtable. I need to be able to add 2 or 3 or 4 additional items in F2 and F3 for the same event in F1. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 |
#2
|
|||
|
|||
subforms
On Tue, 02 Feb 2010 01:56:05 GMT, "thewabit via AccessMonster.com"
u57141@uwe wrote: So I have a Main form with 2 subtables. I made a 1 to many relationship between F1 and F2.....F1 and F3. F2 and F3 are linked to F1 parent/Child with "ObID". Now when I go to the Table for F1, the subtable "+" sign no longer works to pull down the subtable. I need to be able to add 2 or 3 or 4 additional items in F2 and F3 for the same event in F1. Um? Do you have a *FORM* with *SUBFORMS* (which should be fine, and would allow you to do this easily), or a *TABLE* with *SUBTABLES*? If the latter, be aware that table datasheets are not well designed for data entry or editing. They're very limited. For instance, I don't think you can have two active subtables; whereas with a Form you could very easily (if at a performance hit) have ten or more subforms. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
subforms
Yes...I have since learned that what I should have said was "subdatasheets".
I guess I was looking for 2 subdatasheets to drop down since I had two different tables with a relationship with my main table. It looks like it can only do one subdatasheet and they are not even recommended. I got the subforms to work properly... Thanks John. John W. Vinson wrote: So I have a Main form with 2 subtables. I made a 1 to many relationship between F1 and F2.....F1 and F3. F2 and F3 are linked to F1 parent/Child with [quoted text clipped - 5 lines] I need to be able to add 2 or 3 or 4 additional items in F2 and F3 for the same event in F1. Um? Do you have a *FORM* with *SUBFORMS* (which should be fine, and would allow you to do this easily), or a *TABLE* with *SUBTABLES*? If the latter, be aware that table datasheets are not well designed for data entry or editing. They're very limited. For instance, I don't think you can have two active subtables; whereas with a Form you could very easily (if at a performance hit) have ten or more subforms. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|