When entering a new record, I need to lookup and automatically store add'l fields

[bobalston]

I am converting my first desktop app to a web app. One of the capabilities I need to figure out involves looking up and adding data from one existing table to selected fields in the record being entered. The application is one of entering services provided to a client. At the time I enter the date, service and quantity information, I need to automatically populate the service record with selected current values of the client record, such as number of persons in the client household, counts by gender, counts by race, etc, etc. In my desktop app this occurs with VBA code after the user entered data is completed. Can you tell me how I would best go about doing something like this and where I might find an example of the technique?

Bob

[MarionT]

Re: When entering a new record, I need to lookup and automatically store add'l fields

Hi Bob -
I'm real new too, but I think video 75 will get you going -
you're basically creating the join and use the "fill in additional fields"

http://news.alphasoftware.com/v11preview/videos_v11.htm

[zumik]

Re: When entering a new record, I need to lookup and automatically store add'l fields

It's simple.
The filed or fields you update manually ("At the time I enter the date, service and quantity information"), the type of the field must be TEXT -> then you look in the text field's properties until you find LOOKUP (or you click SEARCH PROPERTIES in the up-right cornet and type LOOKUP) -> then select EDIT COMBO LIST -> then hit the LOOKUP DEFINITION -> then select DYNAMIC in the upper section -> it opens a bunch of options, the table you want to look up for information , the displayed information when you click to make a selection (you can select multiple fields to help you decide what you are looking for in the lookup table) -> you should select LOAD DATA METHOD to be AJAX CALLBACK -> and the most important option FILL-IN FIELDS, which will populate the fields in the current table with data in the corresponding fields in the lookup table AUTOMATICALLY (you just have to manually MAP THE CORESPONDENT FIELDS).

That's basically it.

Mike.

lookup 2.JPGlookup 1.JPGlookup 3.JPGlookup 4 - foll-in fields.JPG

[bobalston]

Re: When entering a new record, I need to lookup and automatically store add'l fields

Thanks for the responses. But I don't want these looked up values to be the result of a user selecting from an item in a list, but rather after I enter several fields, based on the current client (a page variable) I want to automagically lookup in the client table and store data in the record being entered.

Sorry for not being clear.

Alts:
1)I guess I could capture these fields when I select the client, using hidden fields in the grid and Ajax to save each to a session variable and then an event (which) after the user enters the manual data to populate these fields into hidden fields in the new grid record.

2) perhaps initiate an update query to update the newly entered record with data from the client record

bob

[Davidk]

Re: When entering a new record, I need to lookup and automatically store add'l fields

You could initiate an ajax callback, get the data from your table, then populate your grid. If it's a SQL table have a look here for the xbasic code to do this - it's a recent post - today

http://msgboard.alphasoftware.com/al...sion-variables

If you need further help initiating the callback and populating the grid, just say.

[Davidk]

Re: When entering a new record, I need to lookup and automatically store add'l fields

You could also use Action Javascript, initiated from any field, or button, "Look-up and fill in fields". I'll bet this is exactly the same as writing code... except it's all done for you. Yay!