TougToug Posted January 27, 2005 Share Posted January 27, 2005 Hi, i need to do a simple calculation on a field in my db for auto-entry, but i'm getting confuse between what i can do and NOT do and between the sripts step that i cant use (or don't know how) and functions. Here it is: I am listing in 4 different fields the assembly or part of the assembly that needs to be tested. the 4 fields are: Part No Joint ID Tube No Connector No for a bit more information, i can test a full assy (part no) or a tube on its own (tube no) or a connector on its own (connector no) or and that's where my problem is, a connector and a tube (Joint ID = tube no + connector no) Now i have an existing list of "Tube no" and "Connector No" but i need a calculation that creates automatically a joint id when i select a tube + a connector, and checks as well if the couple alreadyy exist or not (so that next time i use the same tube+connector the same joint id is used) So far i have a table for connectors and one for tubes, and one for joint with "joint" "tube" and "connector" fields in. few, i hope i've been clear enough, if not let me know and i'll try to explain it better... Thanks for any help, GREAT FORUMS ! ! ! Link to comment Share on other sites More sharing options...
This topic is 6623 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now