Hi
New to this forum and to Tada (only been playing with Tadabase for 2 days)
So here is my little issue, basically, how do I use a related table records in the form I am working on
Let me illustrate
I have a basic user table: USERS(name, email, role, location join)
Each user (record) on the Users table is connected to a single location (that they belong to) in the table: LOCATIONS(location, region)
We also have different location machinery where each machine belongs to a single location and a location can have as many machines as we want. Following table illustrates this: MACHINES(location join, machine name, hourly throughput constant)
We then have a shift report that needs to be filled in by the user. The user logs in into the system clicks on the report and fills in the shift report that ends up in the table: REPORTS(location join, machine join, hours worked, hourly throughput constant) . Each Report will be connected to the Location (via user), Machine (selected by user and based on Machines available at the location).
The Report is a Form Page that really only collects two pieces of information, what Machine is used and the “hours worked” collects the data. The Report is the key tool for data gathering and the main focus for the real users.
Here is where I struggle to get this to work
A) Once the user logs in and opens the Report Form the Location is automaticly defined via the User’s “Location” and is later filled on the Report via record rules. At the same time, as the location is known (user is logged in and has a Location) I want the form to automatically filter all Machines belonging to the Location of the User so that the user can select a Machine from the Machines available in the location. I cannot get this to work
B) In the next step, once the machine has been selected, I want to be able to use the specific Machine’s “hourly throughput constant” in the Report or ideally use it to calculate the throughput by multiplying “hours worked” with “hourly throughput constant”.
I have tied to get this to work and got stuck at point A above. I have done this in Caspio via cascading dropdown fields but I just don’t seem to be able to do this here. Any help highly appreciated.