smacdonald23
New member
- Local time
- Today, 09:30
- Joined
- Feb 8, 2013
- Messages
- 5
I'm wondering if somebody can help me.
I'm building a database for work. I have 2 tables which are called "Customer_ID" and "Ports".
The Customer_ID table has "CUST_ID, PORT, TICKET_ID"
The Ports table has "PORT, STATUS"
The tables are linked via "PORT".
I have a form with 2 subforms for both tables. Basically you create a new "Cust_ID" in the Customer_ID and then search for the next available "PORT" in the Ports table. From here My guys will copy the next port ID into the "PORT" field in the Customer_ID table then they click a button I want it to look at the PORT field in the CUSTOMER_ID table search for it in the PORT table and change the status from available to working.
Can this be done
I'm building a database for work. I have 2 tables which are called "Customer_ID" and "Ports".
The Customer_ID table has "CUST_ID, PORT, TICKET_ID"
The Ports table has "PORT, STATUS"
The tables are linked via "PORT".
I have a form with 2 subforms for both tables. Basically you create a new "Cust_ID" in the Customer_ID and then search for the next available "PORT" in the Ports table. From here My guys will copy the next port ID into the "PORT" field in the Customer_ID table then they click a button I want it to look at the PORT field in the CUSTOMER_ID table search for it in the PORT table and change the status from available to working.
Can this be done
