I have a 1-Many relationship set up, with a master table and a Notes table to allow me to record multiple sets of notes against my master table record. eg Master Table: Notes Table Design Meeting Aug ...

I want to have a simple dashboard record that can summarise information from one (or more) other tables. I want to count the records and total some fields. I have managed to make this work by including a field that I can use the rollup on, but thi...

Hi, I want to automatically populate any new row with the concatenated results of a query of a single field from another table. eg For a new row in table A, I want to select column X from table B and concatenate all the “X”'s into a field in this n...