Make a relationships between the two tables, Invoice Table ::Client Name = Client Table::Client Name...client name in the Invoice Table is pop up menu or drop down menu it depends on you check auto complete using value list...the value list is from the field of Client Table (use Values from field client name). then your fields in your Invoice table the options should be lookup..(Invoice Table::Street Lookup) options..looked-up value..specify...look up from related table...Client Table....copy value from field ::Street...do this to all the rest you want to be automatically entered when you choose the client name.
Great, thanks fro the reply! Will get on to that and see how I get on. Many thanks once again!