Gossamer Forum
Home : Products : DBMan SQL : Discussion :

How DBMan SQL manages relational data structures

Quote Reply
How DBMan SQL manages relational data structures

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!