Posted by Mazin07 on 10/09/34 11:28

JIM WHITAKER wrote:
> This is a very complex system, and all works perfect on a five computer
> network.
> By the way, choosing a shipper in a combobox fills in "ALL" necessary fields
> for pickup, i.e., Address, contact person, phone number for directions, etc.
> Can a web database even do something like this?

Well, if you have one table of shippers, then all that should be
necessary is to give the name/id of the shipper's data, and then submit.
If you want real-time type fill-in, you could try AJAX, but that
doesn't seem necessary.
Theoretically, you don't need to fill-in that data - you should be able
to provide the shipper name and have the script call up the data.
>
> When I migrate to a "Web" database, I am looking for a good PHP script /
> code / example that can handle this situation of dealing with multiple
> lookups on one form, and filling in all required information without having
> to type it in each time.
>
> Ok PHP folks can this be done and where are the examples to learn off of?
>
> To put it in a nutshell, I know how to populate a table, search, and edit
> records in php. What I need are example of: Say you are entering a new
> record, I need a "LOOKUP POPUP TABLE" with a search (enter search string)
> like above, and a way to select a row, then the "LOOKUP POPUP TABLE" closes
> and the original record I was entering has certain fields filled in. Liken
> this to the "Northwind" example that comes with MS Access. In an order
> example, they have some customer info auto filled in.
>
> If all I needed was table / forn / search / edit, I could use DADABIK.
>
> And one final question, Do I need a web database, or is it possible to
> still use MS Access as a front end from another city / state in a client
> server setup? I know how to network all this but not client / server from a
> long distance.
>
> Please if some knowledgeable person reads this, please reply.
>
> Thanks
>
>
>

[Back to original message]