Saving Form Data To Two Tables

[xmeb]

Hi:

I have a form that has approximately 20 text boxes and combo boxes that saves to a table. I need to add a couple more fields. I was reading about normalization and was wondering if I have a problem.

For instance, the user selects a primary location from one (and only one) of three combo boxes (areas/building/places, roads, and condominiums/lodging) and a secondary location (again, only one) from a similar group of four combo boxes. Should I have a separate table with two fields (primary location and secondary location) and save to it? If so, how would it best be done?

Thanks,

xmeb

 

[dhookom]

Tell us about your tables and data, not forms.

Duane
Hook'D on Access
MS Access MVP

 

[LaurieHamlin]

If the data has to be recorded into 2 separate tables, you will need to use 2 recordsets in the form. That means making the form unbound.

 

[TheAceMan1]

How are ya xmeb . . .

In parallel with dhookom, we need to know whats in your tables and your table relationships ... first!

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[xmeb]

I have one table with about 20 fields and I thought it would be better to save related data (like locations) to a separate table. Thanks.

 

[xmeb]

I have one table with about 20 fields and I thought it would be better to save related data (like locations) to a separate table. Thanks.

 

[LaurieHamlin]

It depends on the relationship between the data in the table and the other data. If each record in the table you already have will have one record for the new data, I'd put it in the same table. If it's going to be a one to many situation, it should be in another table.

 

[TheAceMan1]

xmeb . . .

Sorry to get back so late.

I was reading about normalization and was wondering if I have a problem.

Then you go on to say ...

user selects a primary location from one (and only one) of three combo boxes (areas/building/places, roads, and condominiums/lodging) and a secondary location (again, only one) from a similar group of four combo boxes.

Forgive me but roads as a location completely flipped me out. You need to work on your table structure and relationships before questioning normalization. What these relationships are ... only you know.

Since this is a problem with structure, an expulsion of any relationships and how their defined is in order.

Your Thoughts . . .

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[xmeb]

Yes, a road is very much a location. When we have a motor vehicle crash on a given road the location of the motor vehicle crash is the road. Cross streets and landmarks are used to identify exact locations on longer roads. There are other examples as well. Thanks.

 

[TheAceMan1]

xmeb . . .

Thats a new relationship on me (and I bet others). Soooo ... in words ... how are you defining the relatinship between primary & secondary locations?

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]