At 09:14 AM 9/18/2003 -0400, Karen Tellef wrote:
I have a question about how you do forms when NOTE columns are in a different table (which is something I've never done yet and haven't experienced problems). What if the row of data does not have a note yet? Are you setting up a 2-table form? If so, then you would get the "no editable data" for the note field; do you have a button to "add a note" or something like that? How do you make it easy for a user to add a note when there wasn't one before?
Karen,
If the database and tables are designed properly, such as PRIMARY KEY (for the Main Table) REFERENCED to the FOREIGN KEY (for Slave Table), then, all you have to do is to have a Push Button with (Add Row) in 6.5++/7.0 or DB Navigator (+) in 7.0 to Add a note when there wasn't one before. It should automatically reference the key column in Slave Table to match the same column in Master Table (One-To-Many Relation).
Have Fun!
Very Best R:egards,
Razzak.
