preboredo
-
Button with script to populate table
Hi. I have a database as per the model in the picture. 1. Table with students. 2. Table with classes. Each class has a table of students (3) picked up from 1. 3. Table with assignments.…
-
Form with info of current record + 2 before + 2 after
Let's say I have records of sessions of a club. I want create a form where I have the information in the current record ( a date, fro example) but I also want to display the date of the two previous…
-
How do I select a specific field of a record to display in a formula?
I want to display the text for code A2. Something like "select text in Table1 where code is A1".
-
Selecting n records from a table into another table
Hi. I have a table D with a number of assessment criteria, each with an associated level; and I have a table S with names of students and their levels. I'd like to have a subtable in S that…
-
select and concatenate
I have two fields: 'name' and a 'yes/no' choice. How do I select and concatenate the names marked as 'yes'?
-
Attendance record
This my setup. I have 1. Table Students1 (all students) and 2. Table Classes with: - 'Linked from' table Students2 (subset of Students1 that belong to a class) - Sub-table Sessions (with date and…