Hi,
I have created a form where you can select a customer from a select list, from this I then want a number of attributes, such as:
ContactName
Address1
Address2
PostCode
PhoneNumber
To populate automatically. All of this information is stored in one table and can be easily gained with a simple of sql:
Select ContactName
,Address1
,Address2
,PostCode
,PhoneNumber
From Customer
Where CustomerID = P9_CUSTOMERID
I have been looking at a number of different threads and one talks about using AJAX:
1493835
Is this the only way and if so how can I adapt this to enter multiple fields?
I would of thought this is a fairly common requirement so was wondering if there was an inbuilt function to do this, I have been playing with default values but can't seam to get it working.
Any help would be great as I just can't seam to make any progress on this.
I'm using application express 2.1 if it makes a difference.
Many thanks
Ed