Please....is this possible

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 18 Aug 2005 15:18 GMT

Hi There

I have had a look on the site for a simliar posting but cant find one.

I have a basis form done but wondering if I could do the following.

I have a database with say one table name customer.

In the form have a text boxed named CustomerID, also on the form have
several other text boxes.

When a user enters the customerID in the CustomerID text box, the other text
boxes populate with the customer details.

Is this possible and if so how difficuult would it be too implement. Is
there instructions already around?

Thanks in Advance

Kindest Regards

Peter

Reply to this Message

Adam Harding - 18 Aug 2005 15:59 GMT

Yes it is

It would be a lot easier if the ID and the Name are in the same table then
you put Customer ID as the variable field, make the second field populated to
customer name, make read-only and then click X-path next to the Entries Field
and select filter. Then make the Customer name in this box equal to :- click
field in the option list, select your main data source from the Drop-down
list at the top and find the Customer field. click on this so that your line
reads something like

Customer is equal to Customer* where Customer* is the field in your main
data source. Check that your output is then correct and you are done. For
further help search on FILTERING in the search box.

Cheers Adam

> Hi There
>
[quoted text clipped - 18 lines]
>
> Peter

Reply to this Message

Kenneth - 18 Aug 2005 16:05 GMT

Hi Peter,

Just look down on the list on the same page. There is a post I did. The
title is "Dynamic SQL query". Scott had an excellent answer for it.

Ken

> Hi There
>
[quoted text clipped - 18 lines]
>
> Peter

Reply to this Message