Ask Your Question

Complex Base form/query question [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 22:20:26.315739

1 answer

Sort by » oldest newest most voted

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 link more


@QcGreywolf -- Does this answer solve your problem?

qubit gravatar imagequbit ( 2013-03-13 11:03:39 +0200 )edit

Question Tools


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

Seen: 1,732 times

Last updated: Jan 12 '13