You can have relationships in the Relationship builder, just don't create Lookups in table.

For dependent comboboxes, review http://www.datapigtechnologies.com/f...combobox2.html