Complex Base form/query question [closed]
I believe a little background info is necessary first to make sense of my question.
The setup- I have 3 tables with different sets of data 1) A massive table with about 17000 customer entries (numerical designation, name, points of contact, phone #'s, addresses (broken down into components, state, city, etc) and more). 2) A list of employees and relevant data (names, numbers, addresses, etc). 3) A scheduling table (dates, weeks, temporary phone #'s, problem descriptions and more).
Here is where my question may get a little fuzzy, sorry, I am new to Base and its terminology.
I am eventually creating a 'schedule' that displays current data from the schedule table and 'links' data from the other 2 tables.
For example- The schedule table has a 'customer number' entry. I want a form that displays relevant fields of customer information (from the customer table)as soon as I type in the customer number, to assist in scheduling the task.
Or, when I assign a employee to a task on the schedule, on a different form I would like to see what all tasks he has been assigned on the schedule (sort able by different columns of data).
The real question, I suppose, is how do I display data from 3 different tables in one form. Currently, I can set up a combo box with a list of data from one table, but I cannot get that combo box to 'affect' any other fields or forms or display any data from that row or column anywhere. I can also design a form that looks like what I want, input data the way I want, but I cannot get fields to 'auto populate' pre-existing data.
Is there a really comprehensive list of commands/tutorials on some of these advanced features? I have been doing a few hours of googling and everything I can find is the really basic stuff (how to create a form, how to make a table, etc). Is what I am looking at doing within the scope of Base?