please help

[subs]

what would i do if there are multiple
records and the user want to enter only once
for example there is a table as follows


Region Carrier
North
North
North
south
west


Now the form should ask for the user to enter the carrier for
northern region only
once . It should then populate the first three rows with the same
answer. similarly for south and west regions

how should i create such a form

 

[banem2]

what would i do if there are multiple
records and the user want to enter only once
for example there is a table as follows


Region Carrier
North
North
North
south
west


Now the form should ask for the user to enter the carrier for
northern region only
once . It should then populate the first three rows with the same
answer. similarly for south and west regions

how should i create such a form

What you need to do is to normalize database - create new table with
"IDCarrier" and "Carrier" fields and link it with Carrier field in
your table.

It is not good idea to have repeatable text data in table as it often
makes different issues. In new table you will have 3 records:

North, NorthCarrier
South, SouthCarrier
West, WestCarrier

When you update any of the carriers name here, it will "update" all
fields in your table.

Regards,
Branislav Mihaljev, Microsoft Access MVP