The power of relationships. Auto-assign each customer an ID number. But including that number on all order records.. they are linked. Then you can use whatever fields from Customer that you need on orders.
Through a portal on the Customer record you can see a list of orders and with a script/button navigate to that specific order. The relationship goes both directions.
Without knowing your data structure, let's say you have a "company" table that records company name, address etc. Then you have another table, let's call it "orders". The two tables are related. On a layout based on "orders", in layout mode, use the field tool or "insert/field" menu command to place the company name and address fields (from the "company" table)on your layout.This is a very oversimplified explanation. Some people would have a table for company name and another for address. However, since every company must have an address, one company table should suffice. There are many ways to set up an order, especially if the order consists of several "line items". You could search this forum to find questions and answers on these topics.
Thanks for the advice. I am slowly getting to grips with relationships etc and seem to progressing, so will give your suggestion a try!
Thanks. I'm getting to grips with the database, slowly but surely!