Relating forms

[Guest_imported]

I have a form displaying info relating to each customer, each time the customer rings, I'd like to create an incident and record this.
So for instance I 'd like to create a button that when on client 1, opens all the incidents relating to client 1, etc.
Is this possible?

 

[Bry12345]

Presumably you've established a one-to-many relationship between your table containing the customer info (one side) and a table containing the incident records. The tables should be related by a primary key in the one side table (a value that is unique to each customer) and a matching value (foreign key) in each row in the incidents table relating to that customer.

If this is the case, the easiest way to display this information is using a subform to display the incidents for each customer, instead of using a button to open a separate form. To do this, create a second form containing the incident information and drag that form onto a blank area of your main form.

The open the subform properties after selecting the entire subform and make sure that the Child and Master linkings are set to your primary and foreign keys.

When set up properly, all the incidents for each customer will be display in the the subform. You can set the subform property to continuous forms to give you a subform that allows you to scroll thru all the records relating to the customer. - - - -

Bry

 

[SBendBuckeye]

If you use a continuous subform based on a query linking the two tables together, then the system will automatically keep them in sync for you. Make sure that you include the primary key (eg customerID) on the subform so that it automatically updates as you move through the primary form.

 

[Gazer44]

You can take this a stage further by putting a button on the continuous form to view just 'that incident' in more detail.

And also put a button on the main form to add NEW incidents, relative to a particular customer.

I've knocked up a small database showing these features which you can look at if you wish. Post your email address and I'll send it.

cheers,
gary

 

[SBendBuckeye]

Hello Gary,

Thanks for your helpfulness to Carri. I would appreciate seeing your example as well. Thanks for your help.

SBendBuckeye
landgwiney@characterlink.net

 

[Bry12345]

As to the 'syncing' . . . the subform does not have based upon a query linking the two tables. A query returning just the rows you want on your subform from the 'many' side will suffice. The 'syncing' is accomplished through specifying the primary and foreign key in the master/child linkings. - - - -

Bry

 

[JohnHarkins]

Hi!
I'd like to see Gary's sample code, too.
Thanks, John Harkins

 

[Gazer44]

Have sent d/b to SBendBuckeye, if JohnHarkins is interested post email address.

 

[Ynnej]

Thanks a million everyone!

Gary, my address is "mimi-zenado@hotmail.com"!

Thanks again,

 

[Guest_imported]

My address is noseyj2000@yahoo.com

Thanks for all your help

 

[dbourdea]

Gary,

Would like to see those examples as well.
david.bourdeau@bourdeauent.com

 

[JohnHarkins]

Hi, Gary!
My e-mail address:
Accuratus@earthlink.net
Thanks,
John Harkins

 

[Gazer44]

have passed d.base onto addresses above.