Creating a form with multiple entry items per record.

[slimshaney]

Good Afternoon,

I'm trying to create a database that will allow me to log the details of IT equipment across various sites.

I need to create a form that will allow me to input these details. Some equipment such as: Servers, Devices, and Wifi will have multiple entries per site.

I do not know how to create a form that will allow me to do this.

I've listed below what I'll need to achive, and attached a copy of the database so far.

Any help or advice would be most appreciated.

Many thanks,
Shane

The form will need the following:

(Site Details)
Analyst Name
Site Name
Address 1
Address 2
Address 3
Address 4
Post Code
Contact Name
Contact Telephone
Connection Type
Riverbed (Yes/No selection)


IP Range From
IP Range To

(Server Details) Multiple servers per site, so multiple entries required
Server Name
Server Type
Server Model
IP Address

(Device Details) Mulitple devices per site, so multiple entries required
Device Name
Device Type
Device Model
IP Address

(WiFi Details) Multiple wifi networks on some sites, so multiple entries required
WiFi/SSID Name
Location
Passphrase
IP Address

[Missinglinq]

Basically, you'll need to

1. Add a SiteID field, which can simply be an Access-generated Autonumber Field on the Site Table, as the Primary Key.
2. Add a SiteID field to each of the other Tables, but here it'll be defined as a Number Datatype (Long) and will be a Foreign Key for those Tables.
3. Create a Form for each of the Tables
4. Use the Site Table Form as your Main Form
5. Place three Subform Controls on the Main Form
6. Each time the Wizard pops up, give the name of one of the equipment Forms as its Source and if the Wizard asks which fields to use to link the Main Form/Subform, give the SiteID fields (if you use the same name for this field in each Table the Wizard probably won't ask, but rather will just assume that it should use this field.)

You'll then enter info for a given site in the Main Form, and related info, on each type of equipment, in the appropriate Subform. Now, when moving through the site Records, the appropriate related equipment Records will automatically update in the Subforms.

Keep in mind that you'll always need to have a Site Record in the Main Form before entering any of the equipment info for that site.

Linq ;0)>