Predefined table fields

[Entellex]

I am trying to find a simple method to have predefined table fields per Tab in a form



OR

Fill in multiple table fields per control

IE:

If I click a check box, option from a drop-box, or Fill in a text-box when that information gets entered into the table the results will be:

Primary Category	Sub Category #1	Sub Category #2	Input
FOOD	_____	FRUIT	APPLE
FOOD	_____	VEGETABLE	SPINACH

The red will be automatically inserted based on what I chose for the "Sub Category #2" drop-down.
The green will be what I typed in.

[June7]

How should Access 'know' that FRUIT is FOOD and not LUMBER or WHATEVER? Do you have a table that associates FRUIT with the category FOOD?

[Entellex]

I actually do! I have several tables with all my categories.

[June7]

Why duplicate the category value between tables? If the value FRUIT is saved then the category can be retrieved by joining tables.

[Entellex]

The tables I have setup is just to define it. When I enter each record it will all be saved on one table inserting the predefined categories.

This is how I need it to be setup, regardless. I just need to know how to have multiple fields filled out automatically based on what I put in when I add a new record

[June7]

Requires code to save the related data.

Have combobox for selecting SubCategory2 include columns for the other related info. Then code in combobox AfterUpdate event can reference columns by index to save those values. Column index begins with 0.

I use only VBA:

Me!Category = Me.comboboxname.Column(1)

There is macro equivalent that uses SetValue method.

[Entellex]

Thanks for the help!