I have a base with 2 tables - Teams and Projects (as shown below). Every 3 months the leader changes. Now if I update the leader name in Teams table, it updates the leader names in the previous records too in the Project table (because of Lookup). Ho...
Hello all --I am having a challenge bringing in data from a lookup field. We have a table that lists incoming deliveries as each row. There is a column labeled "tags" in this table that where we want to show tags from another table (product details...
Hello!For our organization, I'm working on a view/interface to track changes to lists of content over time. We "merchandise" our content for users in sequential order; e.g. Row 1 of content contains Title A in Position 1, Title B in Position 2, etc.....
I am trying to set up a database of past video shoots, including who worked on them and what position they worked as. I have a table of people, a table of positions (director, cinematographer, producer, audio, makeup, etc), and a table of projects. T...
My goal is to combine 2 data tables into one, and then get a single output sum value for each "agent" within the respective table. Right now, when I combine the tables and syncing, I am getting limited or no data to transfer across. The goal would be...
We're using a base to track actual work done on multi-project invoices, but the invoices from different vendors format the info differently - some tell us a percentage of the time worked spent on each project, while others tell us $ amount subtotals ...
Hi all,For a table as shown above, where only field "item nu" and "Scale" have distinct values for each row while other fields share the same information, how can I automatically fill in the other fields with the common information as shown below? I ...
I am trying to get a sum total of all the hours, demos... Where they can be displayed in an isolated field or additional table. I have tried roll-up and look-up fields into another table with no luck.
I've got 3 tables - 1) Athlete, 2) Athlete Races and 3) Athlete Weekly Training Score. 1 is linked to 2 and 3, but 2 and 3 aren't linked. 3 is updated every week, with a new entry (score) per athlete each week.For any relevant entries in 2) (i.e. whe...
Hello, I'm working on a new database and one of my tables includes various types of barcoding equipment. Each record should have its own unique Serial Number, so I made Serial Number my Primary Field for that table. I thought that, by default, the ...
