Christian Hamel
|
| Posted: 07/27/2001, 12:59 PM |
|
Hello.
I have a table named Employees and a lot of sub tables like
Employees_Languages, Employees_Files, Employees_Jobs etc...
Those are all one to many tables..
How can I construct a form using CC to permit my user of searching for field
that can be in all thoses tables? I thought of creating a Queries that
would link all thoses tables but then I will duplicate many times my record.
Is there a way I can solve my problem? Thanks for any help.
Regards,
Christian
|
|
|
 |
Walker P.
|
| Posted: 07/29/2001, 5:29 PM |
|
To begin with, make sure that your database tables abide to relation
database design rules such that there is a foreign key in the secondary
tables which correponds to the primary key in the main table. You can then
create a search form that has listbox that search against the secondary
tables. You use the field property window of the listbox fields to specify
the relation between the main table and the secondary table. To get an
example of how this is done, you can look at most of the example
applications which come with CodeCharge. You will find a number of search
forms which have such listboxes as mentioned above.
Walker P.
CC Support
|
|
|
|
batman
|
| Posted: 08/02/2001, 2:20 PM |
|
WOW, I did not know that it was so easy to make a a webpage wich uses two
tables in relation.
i just used the form properties to display the placename wich was JOINED
with a placeID
i think i am going to like this program.
bart
|
|
|
|
|
