Creating a form to append a table with values from other tab

[zima8172]

Hi,

I have built an Access DB containing 3 tables: dimensions, time, companies. The tables are not linked and are to be used to look up values for the new form. The goal is to create an Access form that would allow the user to select distinct values from all 3 tables, enter some own data and then execute an append query to add the record to the main table.

Something like this:

Initially I have 3 tables:

Prepopulated Dimensions table with fields:
dimension
....

Prepopulated Time table with fields:
Date
Day
Month
Year

Prepopulated Companies table with fields:
Company
....


My form is to be able to select distinct values (combobox) from all three fields:
Company
Dimension
Day
Month
Year
Value (data entered by user)

The record then is appended to the Main table containing:
Company
Dimension
Day
Month
Year
Value (data entered by user)

Thanks a lot for your time and help!
Polar

 

[Andrew Fergus]

Hi

The way to achieve this is to create a 4th table (like your description of what you want to append), build a form that is linked to this table, and then swap the bound fields on this form (ie delete them) for combo boxes, that you bind to the relevant fields. The combo boxes should be designed to look up the values you want to store from the other tables.

HTH, Andrew

 

[zima8172]

Thanks Andrew, worked like a charm!