TIP: Click on subject to list as thread! ANSI
echo: paradox
to: TROY DAVIS
from: LEE MOST
date: 1995-09-19 04:46:00
subject: Re: Multiple tables/one f

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)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.