Hi Donn,
>> 'Invoices for ' & Lookup('CustomerName','Customer','CustomerId='p_web.GSV('cus:CustomerId'))
It's not quite as simple as that, but it's not terrible.
A) in the form heading field put the name of a local variable - ie somethign you create in the data pad. like donn:header
B) in the embeditor go to the
Heading Routine
this is where you can set donn:header to whatever you want.
So, now you have a couple options to load the related record, and get the customer name. first the obvious;
Access:Customer.Openfile()
Access:Customer.Usefile()
cus:CustomerId = p_web.GSV('cus:CustomerId')
Access:Customer.Fetch(cus:idkey)
donn:header = 'Invoices for ' & cus:CustomerName
Access:Customer.Close()
If you have myTable then it's a bit simpler;
mt myTable
mt.get(Customers,'id',p_web.GSV('cus:CustomerId'))
donn:header = 'Invoices for ' & cus:CustomerName
there's also a p_web._LoadRecord method
p_web._Loadrecord(Customers, cus:IdKey,p_web.GSV('cus:CustomerId')
donn:header = 'Invoices for ' & cus:CustomerName
which would also probably work (not tested though)
Cheers
Bruce