Recent content by lgeer

Yes ... one for the client and one for the contractor.

Per my the book I mentioned before ... relationships are to enforce referential integrity ("a set of rules that attempts to keep the database complete and with no loose ends.") I understand the reasoning ... with "related" fields in each of your tables there's less of a chance to enter/store...

You lost me at ... why I have to seperate the tables? Would it not be easier to search one table rather than several and having to set all those relationships? I don't understand the need for relationships? Here's the one I was testing ... Tinker :rolleyes:

Thanks again ... I tried your suggestion (in a new test) and I can't get the data from the query to pass to the form now? When they were in the same table ... it was no problem, now it can't find the data? I tried using the expression builder but it gives me a #Name? <error> I have alot of...

THANK YOU !!!! That was it ... and thank you for the information ... makes sense not storing data that you can always calculate ... so do you need to identify the total_price field or can you just assign it in the query as a calcualtion? It seems to me that you wouldn't need that field...

One more try ... Sorry about that ... I have alot to learn about this program! I thought that compacting it would perminently change it? Have to read up on that ... Here you go ... it's a simple dbase that will lead into more as we get this project underway.

Here you go ... I have people in and out of my office and it's OK if they see the cost but I'd like the total cost (to me) hidden. 1st I made a query of the data I'd like calculated, then I pass it to the form using sql. If there's a better way - feel free to let me know! 'm very new at this...

Sorry about confusion ... Once I enter a # of units [no_unit] I'd like it to update my [cboTotal_Cost] combo box - meaning if I go back (after initial data entry) and re-enter some new units [no_units] it would then requery the data and place the results into my combobox [cboTotal_Cost] then...

Didn't work? Should the combobox total_cost be unbound?

Didn't work? I have no clue why? Maybe I'm querying wrong?

I have a field called [no_units] in my tap_audit_frm. I have a combo box just under it that sql-queries [total_cost] based on no_units*price. Q) I'm trying to requery combobox after updating [no_units] user input (combobox idea is to have the [total_cost] hidden from general public until I...

1) Do relationships help in the creation of queries and passing specific information back to forms? 2) How do I use them without messing everything else I've created up? lgeer (aka~Capt_Tinker)

Ya-hoo! That's 2 points for you! Thank you for the help - It works now - I was calling it from the wrong location and didn't realize it!:rolleyes: ~Tinker :D

Sorry about the confusion ... I get a little excited and just start ranting about what I'm trying to achieve ... I have several PROJECTS and each one has different TOTAL_FOOTAGES. I'm trying to seperate them (somehow?) and show the data in a form (Here's an example of the form) Project...

WOW I see a lot of people are as confused as I am ... Like 15 views and no posts :confused: Oh well - Listen if it's any matter - I would gladly email my useless piece of crap to someone to analize? PM me and it's yours ... my boss is going to fire me and hire someone else ... anyone need a...