Form building

  • Thread starter Thread starter Cameron
  • Start date Start date
C

Cameron

I am new at access design, and have a problem I hope to
get advise on.

I need to create two forms, one of which is for admin,
the
other is general use pulling info off of the admin form
(table). I need the admin to create, edit or delete shift
duties and asign them to shifts 1,2 or 3. from there I
need a form for the shift personel to use that will have
3
tabs across the top for shift 1,2 and 3(I can do this
part). How do I link them and have the general form
(table)
pull data from the admin and stay current? Need more info
email me or post it here. Thanks alot!

TIA
 
I'm not sure, but I think that you need clarification of the difference
between forms and tables. A table is the repository for data, a form is
only the user interface which allows one to manipulate the data in the
table. So, if you build your table, and then base each of your forms on
this table they will all have access to the same data. You can alter your
forms such that different forms show all or only some fields from your
table, also so that they allow different access to these fields (ex: you can
add records on one form, and only view them on another)
 
Back
Top