Hi just the workshop and contacts tables. i have no combined table.
im useing the contacts full name as a lookup to fill the attendee field in the workshop table. Now i would like a query that has the workshop, particular attendee and his address ect as well so information coming from both tables.