Linked Forms

[gblaxx42]

Hello All. I am building a databse for the 56th Stryker Brigade in Pennsylvania. I have to track many different types of data for soldiers. (i.e. training info, personnel data, etc) I have created all the tables and forms that I need. Now please excuse me for sounding like such a newbie, I haven't used Access to this extent since college.

I want to be able to pull up forms and have commonly linked info already filled in. By this I mean, I want to fill out a soldiers information (name, ssn, dob, etc) in one form called Personnel Form. I than want to pull up a form called Stryker Course Form and already have the soldiers name in there. Any time I open a form I want the name, ssn, dob show up on that form. This will save the soliders entering information from having to enter a soldiers information in on each form.

Any help would be great and please dumb it down, I am only an Infantry officer.

Lt Butler

[PianoMan64]

Lt. Butler,

I'm assuming that since you've created all the tables and forms, that you have some kind of reference ID that links all the information that are in all these different tables into a master table with children below the master table.

Example.

Master Table is Soilders Personal information (Name, Address, SSN, etc.)
And child tables (Stryker course forms table) with some kind of link between them.

If so, just as long as when you open the form with that particular ID to that child record, then you should be able to accomplish what you're trying to do.

Without any more detail as to structure, I wouldn't be able to give a more detailed answer.

Thanks,

Joe P.

[gblaxx42]

Joe,
First off I want to thank you for taking the time field my question. You have to excuse my ignorance with Access. My knowledge is very limited. My Colonel heard that I somewhat knew Access and next thing you know I am building a database for the entire brigade.

So what I have already is 4 main forms. They consist of Soldiers Personnel Data, Stryker Course Required, Weapons Qualification, and 1st Army Requirements. The commonly linked information is (Soldiers name, SSN, Rank). Now I have built relationships with all of the tables linked by the SSN field. So what I would like to see happen is that I would initially fill out the Personnel Data form with all of soldiers demographic information and when I pull up the Weapons form I want only the Name, SSN and Rank filled in at the top. Also, when I reopen the weapons form to edit it, I would like to query it by the soldiers ssn and his form would pop up.

I am not sure what detail you need so I will attempt to explain what I have.

I have four forms linked to four tables

Forms
frmPersonnel Data
frmStryker Course
frmWeapons
frm1starmy

Master Tables
tblPersonnel Data
tblStryker Course
tblWeapons
tbl1starmy

Child tables ( I guess this is what they call them)These table are the tables I pull from when entering into the Master table. (I.e. when I want to enter a position title in the frmPersonnel, I have a drop down from the tblposition table)

tblBattalion
tblCompany
tblPLT
tblRank
tblPosition Title
etc,etc


I hope this makes sense. If this doesnt please give me an example of what you need.

Thank you for supporting you troops.

Lt Butler

[FireMedic]

Lt. Butler,

I'm no Access genius myself but I can think of two good ways of doing this.

1. Instead of basing your forms on the tables, create queries with only the fields you want from your main demographics table and all of the fields from the table that is the main topic of the particular form. Or...

2. Create your main Demographics form and add the others to it as subforms using a subform control and linking them by SSN. You can display all forms in separate controls if space permits or in a tab control with one on each page. Alternatively you can place buttons on your main form to select which subform is to be displayed if you only have space for one.

The button "click" event code would look like this.

Me![[I]subFormCtrlName[/I]].SourceObject =[I] [yourSubFormName][/I]

To find specific records create a combo box on your form(s) using the combo box wizard and select the "find a record on my form" option and follow the wizard.

I hope this is some help to you
Andre Gendron
FF/ EMT / Rescue Tech

Support em all - Home and Abroad - They're All Heros!!