Query Query

Hi experts,

I have created a Master/Detail form for Customers/Invoices using 2 grid components.
I want to add a button to open another form to show the selected invoice (so it can be edited).
How do I pass the Invoice Number (filedname 'ID') to the other form and display the information?

Any help would be appreciated.
Thanks
Freerider.
FreeriderAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
alsantosConnect With a Mentor Commented:
Freerider

Normally, the invoice number is the field[0] so put this on the dbgrid:

"ondbclick" event of the new form:

 after create the new form do this:
 
 newform.edit1.text:=MainForm.dbgrid1.Fields[0].Text;
 newform.edit2.text:=MainForm.dbgrid1.Fields[1].Text;

 and show the newform,

so, the newform will show the selected information.
 
alsantos
0
 
kretzschmarCommented:
multiple possibilities, but too tired, listening  . . .

0
 
marcoszorrillaCommented:
Why not use a Filter
MyInvoiceNumber.Value:=xxxxx;
MyInvoice.Filtered:=True;

And then show the invoice with the Data Aware Controls as Dbedit .... in the other form.

Application.CreateForm(TMyInvoiceForm, MyInvoiceForm);
MyInvoiceForm.ShowModal;

Best Regards.
Marcos.

0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
trex_fireCommented:
Or add the property InvoiceNumber to your form and assign it before showing it.  Then, when you're back, you can validate it or follow the course of action you want.

T-Rex
0
 
kretzschmarCommented:
it goes simpler, later, just waked up
0
 
kretzschmarCommented:
back again, with a cup of coffee :-)

well, i would drop a datasource on your invoiceform and let point the dataset-property to the invoicetable of your mainform, thats all

meikl ;-)
0
 
God_AresCommented:
Good Morning kretzschmar, and how's the coffee 4 u?
0
 
kretzschmarCommented:
>and how's the coffee 4 u?
strong, as recommended ;-)
0
 
TOndrejCommented:
The spice must flow ;-)
0
 
FreeriderAuthor Commented:
kretzschmar,
I tried your suggestion and it works (If I use a DBGrid), but I want to use DBEdit components so I can arrange them properly on the form - when I do this I only get the first record.

They *are* pointing to the correct datasource.
What can be wrong??
-Freerider
0
 
kretzschmarCommented:
>do this I only get the first record.
not really,
the form should display the current record,
which is selected in the childgrid of your mainform

if you want to scroll, within this form,
just place a tdbnavigator on the form,
and connect its datasource-property
to the datasource on the form

if needed, i could code a little sample,
and send it to you (mail-adress required)

hope this helps

meikl ;-)
0
 
FreeriderAuthor Commented:
kretzschmar
>not really,
I *do*!!!??

>the form should display the current record,
I have both the DBGrid and the DBEdit fields on the same form. The DBGrid shows the current record as expected.
They are pointing to the same Dataset - I've checked it a hundred times!
 
A sample would be great:
andrewKEEPYOURSPAMgreaney@snowboard.com

Thanks.

0
 
FreeriderAuthor Commented:
I mean DataSource.
0
 
kretzschmarCommented:
one day later, early in the morning, with a cup of coffee :-))

sample in work

meikl ;-)
0
 
kretzschmarCommented:
sample on the way ;-)
0
 
kretzschmarCommented:
mailing failed :-(

validate your given mail adress
0
 
FreeriderAuthor Commented:
Sorry,

did you take out KEEPYOURSPAM ??
0
 
kretzschmarCommented:
no, what to use instead?
0
 
kretzschmarCommented:
where should i now send it instead?
0
 
FreeriderAuthor Commented:
OK,
can you send it to:

andrewgreaney@libero.it

Thanks.
0
 
FreeriderAuthor Commented:
kretzschmar,

I still haven't received your sample.
Did you manage to send it ok?

Freerider.
0
 
FreeriderAuthor Commented:
kretzschmar,

I still haven't received your sample.
Did you manage to send it ok?

Freerider.
0
 
kretzschmarCommented:
>Did you manage to send it ok?
just now :-)

sorry, for delay

meikl ;-)
0
 
FreeriderAuthor Commented:
Thanks meikl,

I got it to work (using an Access database) - sort of. The only problem is when I open the invoice on a new form, I can't edit the data.

I need to check to see which Table I'm accessing, or do I need to set an option for editing somewhere?...

Freerider.
0
 
FreeriderAuthor Commented:
I eventually used the method suggested by alsantos , but want to split the points as meikl's sample was also very helpfull. How do I split points??
0
 
kretzschmarCommented:
ask at community support for splitting points ;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.