NetNews Usenet Archive 1993 #3/NN_1993_3.iso/spool/comp/database/9422

Text File | 1993-01-27 | 1.7 KB | 34 lines

Newsgroups: comp.databases
Path: sparky!uunet!news.univie.ac.at!scsing.switch.ch!univ-lyon1.fr!ghost.dsi.unimi.it!rpi!utcsri!newsflash.concordia.ca!mizar.cc.umanitoba.ca!ummalik
From: [e-mail] (Ijaz Rashid Malik)
Subject: A question re: Forms in Paradox
Message-ID: <[e-mail]>
Sender: [e-mail]
Nntp-Posting-Host: asimov.cc.umanitoba.ca
Organization: University of Manitoba, Winnipeg, Canada
Date: Wed, 27 Jan 1993 13:00:26 GMT
Lines: 22


Hello,
In Paradox, the detailed form cannot contain any embeded forms. Fine!
I am working with an acccounting+database system. I have a master business
table that houses list of all client businesses. Then there is a detailed
form from Ledger table that shows payment history of each business. There
is a third table called Accounts Receivable which comes under Ledger table.
(Ledger table is its master as A/R table has a field from Ledger table that
identifies which Ledger entry this A/R amount is for). Right now I am using
Business's form as Master and showing Ledger on the same form as detailed
link table. But I also need to show (user's demand) the A/R amount (if any)
for every Ledger entry (for users quick visual reference). But I cant do that
under current set up as Ledger acts as master of A/R and Ledger is already
a detailed form. I thought of making ledger the master but that does not
work since Business and Ledger have 1:M relationship, and I dont want to
add the A/R stuff into ledger table as my Ledger table is already containing
about 8 fields. Any ideas as to how I can display A/R entries on the same b
business form although they are linked to Ledger table?

thanks very much for your help,

Malik