Building Composit key on the fly, Boy Scout Data Base
in [Tables]
|
Prev: pasted record in locked form crashes database
Next: Importing of tables and other database elements into a new databas
From: John... Visio MVP on 26 Mar 2010 20:38 "Steve" <notmyemail(a)address.com> wrote in message news:u2jE5vTzKHA.4656(a)TK2MSFTNGP05.phx.gbl... > > You need a form/subform for entering data. Base the main form on > TblPerson. Base the subform on TblMeritBadgeAward. Set the LinkMaster and > LinkChild properties to PersonID. Use a combobox in the subform to enter > MeritBadgeID. Your form/subform will display a single person and a list of > merit badges awarded to that person. You can sort the merit badges in > alphabetical order. Now all you need do is rely on the data entery person > not to enter a duplicate merit badge for any person. > > Steve You forgot the part about chastising the poster for his table design and that only you can help him --- for a fee. John...
From: John W. Vinson on 26 Mar 2010 20:52
On Fri, 26 Mar 2010 19:27:58 -0400, "Steve" <notmyemail(a)address.com> wrote: >Now all you need do is rely on the data entery person not to enter a >duplicate merit badge for any person. Or you can use Access as it is designed... with a unique index on the two fields. You're not enhancing your reputation any, Steve. -- John W. Vinson [MVP] |