Recent content by rinelson

Ruralguy!!! I can't thank you enough! I've only been on this site for a little while and already have benefitted greatly because of folks like you. I only hope that I'll be able to get better so that I can contribute back. Thank you sir. Rich

Still not there Ruralguy, Thanks for the code sample! I tried it both ways (text & numeric) but still getting the same darn error. I know that I'm an extreme rookie but this is driving me crazy. Here is the actual database...

I'm trying to populate an undound text box on a report and here's the code that I have that's not working. I keep getting a Compile Error: Method or Data Member not found. Here's the code, hope you can help.... Public Function FillGeneral() Dim rs As Recordset Dim db As...

Here's the table: ID field: autonumber ProjectID: lookup to Projects Contractor: lookup to Contractor ParentContractor: lookup to Contractor (this same table) I use this to create the hierarchy of the contractors and subs on a project. I would like the table to show the structure properly --...

Never thought of that!!! Awesome tip... You guys/gals on this site are awesome... thanks again!

Great Start Pat, Thanks for the advice. I'll give that a shot. This may be circular but can I (maybe in the form) have the tblRelationships.SubCompanyID look to tblRelationships.ParentCompanyID to validate that the company being entered is a sub of a sub and maintain the relationship to the...

I am creating a database that will need to track contractors to projects and subcontractors to parent contractor and project. I would like to make it possible to have unlimited tiers of subs on a project and track the "tree" or "orgchart" if you will. The main purpose of the database is to...