Tables fields from more than one table

[aca00js]

What I want to do from form view is to save a a record in my main table (Incident) which takes fields from three other tables. These are the key fields and are foreign keys in the Incident table.

These other tables are also sub forms on my form and one of the key fields (Officer's Collar Number) is displayed in its textbox. The other two are hidden.

So I want to know is how can I saves these fields when I try to make a new Incident Record. I want the current record to be the fields that are used.

So I click my New Button which makes a new incidentand fill in the fields. Then I make sure the correct victim, offender and officer are in the other forms and the primary key fields are then saved within the Incident record.

So basicly I want a button so when clicked builds a record up, but I want to tell the program where the data for each form comes from.

 

[Pat Hartman]

Did you not understand my response to your duplicate post or are you chosing to ignore it?

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47295

 

[aca00js]

I realised that I posted in the wrong section.

I have read your reply and I wasn't clear to the situation I am trying to model. A Incident key fields are the Id and Date. THese are entered by the user from handed in forms. So they have to be typed. The relationship I am using is right. Each incident only has one offender, victim and officer. If there is two victims they are filed under to seperate incidents.

So want I really want to know is. Is there away of telling Access where to get the data for each field in the Incident Table from.

IncidentID = frmIncident.txtincidnetid
Incident Date = frmIncident.txtincidentdate
ArrestMade = frmIncident.tickboxarrest
CID170 = frmIncident.tickboxcid170
CollarNum = frmOfficer.txtcollarnum
ETC

How do i get the current victim id and current offedner id

thanks for your help

 

[Pat Hartman]

Data is not stored in forms. It is stored in tables. You would use comboboxes based on queries that select the victims from the victim table and the officiers from the officier table.

 

[aca00js]

Thanks for the help. How do I actually do a query on the tables to produced the wanted Victim, Officer ad Offender.

Can I use the CurrentRecord function to construct the table.

Thanks for all the help.