Question about retrieving data

October 12, 200421 yr

Newbies

Hi, I am new here and reletivly new to Filemaker. I am just experimenting at this at the moment but am looking into implementing it at some stage soon.

I am looking to construct a Point Of Sale interface (for a retail store) using Filemaker Pro 6 which works in unison with a existing database that stores information about certain products. I am planning to use a portal (or something similar) for this: What I want to do is have 2 database files, one for the products, and one for the POS interface. In the POS interface, i want to have a portal (connected to the products file) with a number of fields: Product#, Product name, Unit Price, Quantity & Total price. With these fields, I only want to have 2 active, Product# and Quantity. With this, I want to enter a product number into the Product# field and a quantity into the quantity field and have the other fields automatically filled in with the appropriate data. This is kinda hard to explain so below is an image of what Id like to do:

I am quite familiar with MySQL and if I could use it in Filemaker, Id simply have a script such as "SELECT * FROM products WHERE product# = 5" for instance. Is it possible to implement such a thing? And if so, can anybody point me towards, or give any assistance regarding this?

Any help is greatly appreciated.

October 12, 200421 yr

This can be done with Lookups, or related calculation fields.

I'd do all new development work in FMP 7 unless there was some really compelling reason to stck with FMP 6. Everything you learn in FMP 6 as you go along will be essentially obsolete...