Record Selector Macros

[Gt394]

I have the following tables.

tbl_customer
CustID Primary key
Custname
Custaddr

tbl_Quote
QuoteNo Primary key
ProjectName
ProjectAddr

Relationship: tbl_cust (one) ---- (many) tbl_quote

I have a form: frm_srchcust (linked to qry_srchcust )

A subform ( subfrm_project ) is nestled in this form. Subform linked to
query qry_viewquote

The frm_srchcust has customers details for a given CustID number.

The subform provides all projects associated with the custID. In the
subform, there are record selectors against each record.

Q: i want to be able to click the record selector for a given record (that
shows a certain Quote No. that i want) and then have the frm_viewquote open,
showing the details of that particular quote number.
Any help would be appreciated.

[Ed Robichaud]

What you request is the normal behavior of Main-Subform setups if the
parent-child link is defined correctly.

In your tables, you don't show a foreign key of [CustID] in the tbl_Quote;
you need one. With it, is the only way you could have a correct 1-many
relationship between the two tables.
-Ed
"Gt394" <g4****@hotmail.com> wrote in message
news:43***********************@news.optusnet.com.a u...

I have the following tables.

tbl_customer
CustID Primary key
Custname
Custaddr

tbl_Quote
QuoteNo Primary key
ProjectName
ProjectAddr

Relationship: tbl_cust (one) ---- (many) tbl_quote

I have a form: frm_srchcust (linked to qry_srchcust )

A subform ( subfrm_project ) is nestled in this form. Subform linked to
query qry_viewquote

The frm_srchcust has customers details for a given CustID number.

The subform provides all projects associated with the custID. In the
subform, there are record selectors against each record.

Q: i want to be able to click the record selector for a given record (that
shows a certain Quote No. that i want) and then have the frm_viewquote
open,
showing the details of that particular quote number.
Any help would be appreciated.