If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
please help
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 |
#2
|
|||
|
|||
please help
subs wrote: 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 |
Thread Tools | |
Display Modes | |
|
|