Dennis is right. I have a cool form, a huge one covering one big monitor. It has 5 DBGrids that are all based on one table. Each grid shows a particular "Status". So each grid is based on a permanent view off that table for the one Status, and each view gives each column a totally unique name (I just put 1 - 5 after the name of each column).
Karen -----Original Message----- From: Dennis McGrath <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, Jul 30, 2013 3:04 pm Subject: [RBASE-L] - RE: Can I do this ? 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.
