adding a single record

[Neil_Pattison]

I have 2 tables and a query to show the details of both tables on a form for an attendance database. The idea is that whenever someone is absent they have a record created.

tbl[Staff] has the following fields StaffID,Name,Team,Job Title
tbl[Absence] has the following fields StaffID, abStartDate,abEndDate,abIssue

I can set up the query to find the member of staff by name but I want to be able to use this form to add new records to the Absence table for each individual. eg I use the query to search for "Joe Bloggs" and the form shows the details from staff table and then use the form to add details to the Absence table.

Any help would be greatly appreciated

 

[RuralGuy]

I would think you would bind the form to a query the combines the two tables and goto a new record when the form opens. Then use a ComboBox to select the StaffMember from the tbl[Staff] and put the [StaffID] in the tbl[Absence].

 

[Sergeant]

You could use a form/subform...
Make your main form bound to the Staff table (or a query thereof).
Make your subform bound to absence table query, perhaps display the form in datasheet view.
Make sure that the child/parent fields are linked (should be by default if your relationship is set up correctly).