Hi, Troy!
TD> In Paradox 4.5 (DOS version), I've created 4 tables (.db files).
TD> userinfo.db, compinfo.db, compsoft.db and compnts.db.
TD> I have created a common link throughout all the tables called Login
ame.
TD> In entering the structure for the table, I used the A8* to signify it as
TD> a key field (as well as for all the other tables). In the Form|Design,
TD> attempted to create a multi-tabled form but I'm not sure what to do from
TD> there. I read the docs but they didn't seem to help. I would like the
TD> top form to be the master form (userinfo.db) and the rest would be slave
TD> forms (for lack of a better term). One more thing, although I used the
TD> Login Name to link the tables, it shouldn't be necessary to use it in
TD> the forms, should it? Thanx in advance,
When you say you don't want to use the Login Name field on all the forms
you are on the right track. The [Login Name] field (I'm using PAL notation
for a field name here) should ONLY appear on the master form. On all the
other forms you create (that you then later Link to the master form) the
[Login Name] field must NOT appear.
The above will only work for one-to-one relationships between tables. If
you have a linked table that has a separate record for each piece of software
that a user has, then that table should be keyed on not one, but two fields:
the linking field, in this case [Login Name], and another field, say
[Software
Name]. In that case, you still must NOT have the linking field on the detail
form (as the "slave" form is called in the manuals) and you MUST have any
on-
linking keyed fields, in this case [Software Name], on the detail form. The
advantage to doing it that way (as opposed to having a whole bunch of fields
for all the possible kinds of software in a table) is that you don't waste
space on empty fields, and you can list ALL the software (or whatever you're
keeping track of) in the secondary table. You can also make the detail form
a
multi-record form to get several records at once on screen, or use F3 or F4
to
go to that table and scroll through the various records.
Hope that helps.
-- Lee --
... If your first thought is "No!" then follow your second thought.
--- Via Silver Xpress V3.02
---------------
* Origin: Silver Xpress [RBBS] (1:125/27)
|