Question

Locked

Creating a form to append a table with values from other tables/data entry

By 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

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

solution

by john.a.wills In reply to Creating a form to append ...

Make the 3 pointers in the main table to the first-built tables the key of the main table. In the main form use drop-down combo boxes to access and choose the 3 key values and have a value box to be filled in.

Collapse -

Thanks a lot for your reply!

by zima8172 In reply to solution

My problem is that when I create the form and use fields from other tables, the combobox does not let me "select" the prepopulated value from the dropdown - it lets me highlight it but does not place in the box itself. What could be the reason? Thanks

Collapse -

SQL

by john.a.wills In reply to Thanks a lot for your rep ...

Take a look at the Select statement for the combo box.

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums