Topic: Having problems
Hi all,
As you will gather i'm a little new to this.
I'm writing a program that basically has 3 main tables, address, jobfiles, stock.
The stockfile collects data from address and stock to produce invoices.
The jobfile stores an invoice address and delivery address selected from the address table.
For the life of me i can't seem to copy an address file into the jobfile however i code it.
I can select the address id but loose the jobfile id, or the other way round, i've tried everything.
Now i'm sure there is a variable that stores an id after focus but no idea what it is, if i could get the whole sql command in one line then it would work.
Then all i will need is a command in the script to refresh the jobfile form.
Hope i have explained this clearly, and again many thanks in advance.
John