Textbox link

[Guest]

I’ve been having problems with this for about two week now, can’t find any info online. I have a table for inventory with a lookup column with (Complete, In Repair, In Shipping, In Receiving, In Office) and only want those be changed in inventory. Then I have several other tables but I'm just going use Repair as example. In repair I have the products with S/N which is what records go by. I need either a label or textbox that just says if it is (Complete, In Repair, In Shipping, In Receiving, In Office) I’ve been using access for a while and have tried everything I don’t know if the relationships are wrong or what I'm doing wrong if anyone can help is lemans terms that would be awesome.

 

[Ken Snell]

Can you give an example of what the form's info will be and what actions you
want the user to take and what you want the database to do? I'm just not
following your description here.

FYI...using a "lookup" field in your table is not recommended...leads to all
types of confusion. See The ACCESS Web for more info re: this:
http://www.mvps.org/access/lookupfields.htm


--

Ken Snell
<MS ACCESS MVP>

I've been having problems with this for about two week now, can't find any

info online. I have a table for inventory with a lookup column with
(Complete, In Repair, In Shipping, In Receiving, In Office) and only want
those be changed in inventory. Then I have several other tables but I'm just
going use Repair as example. In repair I have the products with S/N which
is what records go by. I need either a label or textbox that just says if it
is (Complete, In Repair, In Shipping, In Receiving, In Office) I've been
using access for a while and have tried everything I don't know if the
relationships are wrong or what I'm doing wrong if anyone can help is lemans
terms that would be awesome.

 

[Guest]

Ok I have an Inventory Table and what I did now was put a Table for "Status" within status table is

ID - Status
1 - Complete
2 - In Progress
3 - In Repair
Etc.

Well I have products that go in and out of repair, inventory office, and shipping and reciving. Well in the inventory Form I have where you can change this product's status location, also have it with a drop box. Now in the Repair, Receiving, Shipping etc "Forms" when they look at the product record all i want them to see is the text box or label that has with in it the correct status that is in the inventory colomn. So if they are looking at "Product - 114" with status "In Repair" I want the "In Repair" with in a text box or label on the "Repair Form" so they can't change it. All i want these other forms to do is just show the current status of a "Record/Product" and when i change it in inventory it will show next time someone looks at it in any other form. I dont know how to really explain it any further but if this doesnt help I can try.