G
grep
have 2 forms. Orders and Quotes. First you order from the vendor, then
you can create a quote based on the order. Both forms share a database
QuoteDetail. Reason being that, the same items are going into both -
just one needs the Cost and one needs the Price, so I have them both in
the same table. I therefore have fields in QuoteDetail for OrderID and
QuoteID. Now, when I call the Quotes form from the Orders form, it gets
filtered to show only the record where Quotes.QuoteID =
QuoteDetail.QuoteID. (Or the other way around...)
The problem is that if it's a New record, the filter shows nothing, and
no values get passed to QuoteDetail. So I don't see my detail data in my
Quotes form.
How do I make it update the field to match?
I was thinking that I could have the button click procedure manually
update it, but I'm such a freakin' newbie at this, that I couldn't
figure out how to make that happen.
Thx
you can create a quote based on the order. Both forms share a database
QuoteDetail. Reason being that, the same items are going into both -
just one needs the Cost and one needs the Price, so I have them both in
the same table. I therefore have fields in QuoteDetail for OrderID and
QuoteID. Now, when I call the Quotes form from the Orders form, it gets
filtered to show only the record where Quotes.QuoteID =
QuoteDetail.QuoteID. (Or the other way around...)
The problem is that if it's a New record, the filter shows nothing, and
no values get passed to QuoteDetail. So I don't see my detail data in my
Quotes form.
How do I make it update the field to match?
I was thinking that I could have the button click procedure manually
update it, but I'm such a freakin' newbie at this, that I couldn't
figure out how to make that happen.
Thx