PhotoPath 'URL of the photo on the web server
Product ID FK
A one-to-many relationship exists between the Products table and the photos table, ie: each product can have 0, 1, 2, 3 or more photos associated with it.
How can you perform a query which lists all products and only the first corresponding photo path, yet provides a default values for the Photopath so an "Awaiting Image" can be displayed if there not yet a photo record associated with the product.
I could solve this with a nested query, but that's messy.
NB: Access SQL appreciated.