How does one populate a form with one-to-many data

[WesHarding]

Hello,

I have a continuous form that holds multiple pieces of data, by this I mean for example sometimes people have many phone numbers. I have all of their phone numbers to appear in one box in a continuous form or something similar.

ie, how can I get this data to populate in a form? This is probably simple, but something I just never learned!



Thanks!

[RuralGuy]

Usually we handle 1:m relationships with a Form/SubForm arrangement. The phone numbers would be in a separate table with a field in each record for the PrimaryKey (PK) of the "people" table as a Foreign Key (FK). The SubForm would be bound to the "phone" table and the MainForm bound to the "people" table. Use the PK and FK as the LinkMaster/ChildFields properties of the SubFormControl.

[WesHarding]

Wonderful! Very clear thank you. That does make sense when I think of it now

[RuralGuy]

Post back if you need additional assistance.