Two Queries

[Grey Loki]

Hi there everyone,

I've got a fairly hefty production database going, for a hire company. In this database, the user creates a client record (in tbl_clients), then creates an invoice for this client (tbl_sales), importing line items from tbl_stock into a portal on the invoice layout - standard sort of thing.

In addition to the client's details being on the invoice, there are venue details (name, address, postcode, etc). These were originally manually entered, but now i'd like to make it so that for a few venues that are used regularly, putting in the venue name automatically fills in the rest of the details. What's the best way of doing this? Creating a tbl_venues, linking it to tbl_sales and then getting FM to somehow populate the rest of the details from a linked venue name/venue ID# as selected by the user?

My second question is of a similar vein - often, a client will ask for 'exactly what we had last year'. This is great, except for large invoices of 40+ items, where it becomes tedious to have to re-enter every piece of information (client details, venue details, and which items were hired) again. What's the best way of copying every piece of information on an invoice (including line items held in the portal, which are being taken from tbl_inventory), creating a new invoice, and then pasting all of this information? I can figure out how to get the fields copied across (mostly, heh), but i'm stuck when it comes to duplicating the contents of the portal.

Thanks for any help.