English
Ask Your Question
0

Complex Base form/query question

asked 2013-01-11 22:08:12 +0200

QcGreywolf gravatar image

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?

edit retag flag offensive close delete

1 answer

Sort by » oldest newest most voted
0

answered 2013-01-12 01:50:41 +0200

phree gravatar image

Create a query including all of the fields from all of the tables that you need on the form. Then build the form using query fields and fill control boxes based on your selections in drop down fields on the form. You can use drop down combo controls on the form that will autofill or create a prompt that asks for customer # and then fills the related fields.

edit flag offensive delete publish link more

Comments

@QcGreywolf -- Does this answer solve your problem?

qubit ( 2013-03-13 11:03:39 +0200 )edit
Login/Signup to Answer

Stats

Asked: 2013-01-11 22:08:12 +0200

Seen: 770 times

Last updated: Jan 12 '13