Subforms

[knarlyd@hotmail.com]

I have a db with 2 tables. Main table has ID (autonum, primary), Last, First, Email, Folder
2nd table has ID(number) Last, First, Folder

I have set ID as the relationship between both tables (one to many). I just noticed the ID on the second table has no number in any of those records. I assume that's a problem! arg.
I created the subform but from there I'm not sure what I'm doing.
Here's an example:
One person can have multiple folders. How can I show that customer1 (for example) has one or more phone #'s associated to them? I also want the end users to be able to add/edit add'l phone #'s associated with each record.
Also,the folder from the second table is not unique and can have duplicates.

Currently when I view the subform (on same page as main form), it's showing phone number from both table one and table 2, so I'm seeing 2 records on the subform.

I think a subform is the way to go however not certain? I wish I could post the db but it's got confidential info.
Suggestions, etc are *greatly* appreciated!
Hopefully I can get some replies before my meeting tomorrow before 11 am US pacific time!
TIA

 

[Ranman256]

Yes , the subForm would connect to the tCrediCards table.
TCreditCards
------------
CCID (autonumber)
ClientID. (Long)
CcName
CcNum

The clientID would join the master tbl tClient.ClientID.
In the subForm ,set the form properties, LINK MASTER ID, and LINK CHILD ID

You can then enter all the credit cards needed, for 1 client.

 

[knarlyd@hotmail.com]

Yes , the subForm would connect to the tCrediCards table.
TCreditCards
------------
CCID (autonumber)
ClientID. (Long)
CcName
CcNum

The clientID would join the master tbl tClient.ClientID.
In the subForm ,set the form properties, LINK MASTER ID, and LINK CHILD ID

You can then enter all the credit cards needed, for 1 client.

Im not sure if this changes things at all but the credit card (or folder as a better example) is not unique as \personA can have a folder 1234, and personB can also have folder, 1234

 

[knarlyd@hotmail.com]

Yes , the subForm would connect to the tCrediCards table.
TCreditCards
------------
CCID (autonumber)
ClientID. (Long)
CcName
CcNum

The clientID would join the master tbl tClient.ClientID.
In the subForm ,set the form properties, LINK MASTER ID, and LINK CHILD ID

You can then enter all the credit cards needed, for 1 client.

Still not working correctly. When I enter data in the subform, it's not saving it...arg:banghead: