I have table ‘Submissions’ that records each item submitted by users. Each entry has the Username of the user who submitted, and a Points value according to the Type of item submitted. I need to aggregate the Points for each user in a separate table....

I want to use the cells in a single-line table as ‘constants’ that can be used by another table. For example: The Products table has product details and one column is Colour. Associated with each Colour is a ColourValue (in an adjacent column). The C...

I have a vacation rental database. In the Bookings table each booking has a unique BookingRef and a RentalAmount (e.g. $2000). Payments against the total amount are made in stages, tracked in a Payments table that ties each transaction to the unique ...

I have a field where many of the entries are repeated multiple times (e.g. Management; Maintenance; Utilities) but there are also a lot of one-off values (e.g. Emergency Repair), so it’s not suitable for a Single Select field type. What would be hand...