Hi, Dick - I've done this where I've created three single-table views - each having the appropriate WHERE clause, and each having the alias names unique except for the primary key field.
Then you can place the three sets of data on three different tabs. CREATE VIEW View_a (col1_a,col2_a,col3_a) AS SELECT col1,col2,col3 FROM table + WHERE column = 'a' CREATE VIEW View_b (col1_b,col2_b,col3_b) AS SELECT col1,col2,col3 FROM table + WHERE column = 'b' CREATE VIEW View_c (col1_c,col2_c,col3_c) AS SELECT col1,col2,col3 FROM table + WHERE column = 'c' Have fun! Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Thursday, January 08, 2009 10:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Form Design I probably still have the news years hangover, but am trying to construct a form and I can't figure out how to make it work. Making a 3 tab form used to balance the check register using the bank statement. Each type of entry in the check register has a code, Deposits, Withdrawal, Checks. (D, W, C) I want to put a scrolling region on each page, page one that will only show the lines coded as a deposit 'D' Page two only shows the 'W' items. Page three only shows 'C' items. I thought I could put a where clause in the on tab entry eep, but can't figure out how to do that. I currently do the same thing using 3 forms, but it would be nice to put it all together. Ideas anyone ? Thanks Dick Fey Carpet Broker Inc.
