<div>
For example, I would like this to work like the ability to add more than one phone number in a form
</div>


For example, I would like this to work like the ability to add more than one phone number in a form

<div>
So you want to be able to add multiple &quot;child&quot; items to a single &quot;parent&quot; record? Using your example, if you're viewing a Customer record, you want to be able to add multiple Contacts to that Customer record?<br />
<br />
If so, you should add a Contacts table, and relate the Contacts table to the Customer table:<br />
<br />
tContacts<br />
---------------<br />
ContactID<br />
CustomerID<br />
ContactType<br />
Contact<br />
Notes<br />
etc etc<br />
<br />
You'd then create a form (datasheet or continuous) and embed that form in the parent form. Set the Master/Child links to the correct values, and you can then add as many Contacts to a Customer as needed.
</div>


So you want to be able to add multiple "child" items to a single "parent" record? Using your example, if you're viewing a Customer record, you want to be able to add multiple Contacts to that Customer record?

If so, you should add a Contacts table, and relate the Contacts table to the Customer table:

tContacts
---------------
ContactID
CustomerID
ContactType
Contact
Notes
etc etc

You'd then create a form (datasheet or continuous) and embed that form in the parent form. Set the Master/Child links to the correct values, and you can then add as many Contacts to a Customer as needed.

<div>
<div class="content wysiwyg-content">
I want a <u>text box</u> and a<u> combo box</u> to be a repeatable grouped unit of fields in a form please.<br />
<br />
How should I go about this?<br />
<br />
With many thanks!
</div>
</div>


I want a text box and a combo box to be a repeatable grouped unit of fields in a form please.

How should I go about this?

With many thanks!

ACCESS: Create a repeatable unit of fields in a form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.