>Hi John,
>
>is your primary question how to create database relations, or is this more of the system architecture issue: how to present related information on a web page?
>
>Igor.

Hi Igor

My primary question was what was the best way to get order and invoice records that are displayed on grids on a page frame to sync with the name and address record the table are all separate and us keys to link them together, the general advice seems to be to use parameterised views I was following up with should I create the view at run time or add it to the database at development time and then ship the database. The application is installed on separate machines at the clients address.

John