Or create one view with all 5 tables and use one DB Grid. That would
give you more flexibility in column layout - e.g. you could put all the
price columns next to each other, etc...
Like Dennis said, column names would have to be different for each table
'cept for the sku which I assume is the same in all tables.
Doug
On 7/30/2013 3:03 PM, Dennis McGrath wrote:
Since they all have the same columns, that may be the problem.
Create a view of each one, using unique column names for each one.
Now your form should work, once you get the column names correct.
Remember, RBASE forms will link up the tables by matching column names and data.
Making the column names unique eliminates all linkage as far as the form is
concerned
Dennis McGrath
Software Developer
QMI Security Solutions
1661 Glenlake Ave
Itasca IL 60143
630-980-8461
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey
Sent: Tuesday, July 30, 2013 2:16 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Can I do this ?
Using 9.5 latest build.
I want to create a form that shows 5 db grids, from 5 different
inventory tables, with no relationship to one another.
Point being to view all five inventoried products at a glance.
All 5 tables use the same columns, but are otherwise unconnected.
I could use just one table, with a SKU column to keep it straight, but I
prefer separate tables.
Can't figure out how to do it.
Thanks,
Dick Fey
Carpet Broker Inc.
