Hi
I'm trying to make a very simple database to track the issue of safety footwear. We buy each par as required and I have tables for Customer, Transactions, Footwear type, size and supplier (supplier prob not required so not implemented. I have search forms (customer) which work.But I need to create a form which has a search (Customers Clock code) box, which when filled then populates the customers full Name and his historic records (old footwear) and then allows selection of a new pair of footwear which when (Button Press) adds that new record to the original transaction table. Any help steering me in the right direction would be great.

Kind regards

Colin