I am back to the drawing board on my latest dB. My output of the dB is to create SQL statements for another complex dB. I have the following tables:
tblTableNames, tblFieldNames and tblRelats
There are approx. 300, 2300 and 70 rows respectively for these tables. Some of these 70 relations have circular links. My most complex circular link has 10 tables, a smaller circular node of 5 tables and a bypass link which could make this circular node 8 elements (a short cut).
My goal is to have combo boxes where they can pick Table Names and/or Field names, and then determine if and how the tables link.
My problem is trying to find an easy way to peruse the tblRelats. Because it has "Parent/Child" connections. I'm open to any new suggestions.