Gossamer Forum
Home : Products : DBMan SQL : Discussion :

How DBMan SQL manages relational data structures

Quote Reply
How DBMan SQL manages relational data structures
Hi,

I am looking for a good MySQL Databasemanager for a client giving several users restricted access to their tables.

Q: How manages DBMan relational data structures? E.g. the quite common situation that you have a table A with products related n:1 to a table B with manufactures. How is the adding, modifying, deleting, viewing of records handled by DBMan SQL? When adding a record to table A (e.g. a new product) can I easily generate a form that contains the related datafields of table B (e.g. name and address of manufacturer)? Can I add a new record to table A and table B simultaneously i. e. in one form (for example I want to add a new product in table A and its new manufacturer in table B).

Your information is much appreciated!

Armin
Subject Author Views Date
Post How DBMan SQL manages relational data structures Armin 1632 Feb 20, 2002, 10:17 PM