General information
Category:
Forms & Form designer
Title:
Multi-tabled /Parent-Child/Related forms
Between all of these I am prob just confused with their diffrences
but all I am trying to do is create a form that has it's own data
and also has data that is updateable and linked to 4 other tables.
So basicly you enter the id of a customer in the .....................Anitable
and the Linked field with his name comes up..........................Customer Table
and the linked fields with his Phone#'s comes up....................PhoneNumber Table
and the linked fields with his TollFree#'s comes up..................TollFree Table
and the linked fields with his Calling Card#'s comes up............Calling Card Table
Also you enter his site # and then it pulls in the Site name from the Site Table.
I have done this same thing is Access, and Advanced Revelation
but can not seem go understand how to do so in VFP
Right Now I just have the tables added to the form via DE and dropped 2 fields
on to the form to create the grid. I then right clicked on the grid and used the builder
to modi the grid to just a single field and set it up like i needed. I repeated this
step 2 more time to complete the form. everything works sorta ok but the grids
do not update properly.
Mike D.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only