I am trying to set up a form that I can "justify" the movement of inventory. I have 5 tables:
| The Stock | The Plan | |||
| tblTheStock | tblStockMovement | tblThePlan | tblTheQuestions | tblTheAnswers |
| Stock_ID | StockMovement_ID | Plan_ID | TheQuestions_ID | TheAnswers_ID |
| txtStockCode | Stock_ID | txtPlanName | Plan_ID | TheQuestions_ID |
| Various others | txtMovementType | Various others | txtTheQuestions | AnsChkBx (Y/N/NA) |
|
| Various others |
|
| txtTheAnswer |
|
| Plan_1 |
|
|
|
|
| Plan_2 |
|
|
|
|
| Plan_??? |
|
|
|
The goal is:
For every StockMovement to have a minimum of 1 Plan. Would like to have the ability to have more.
frmStockMovement
tblTheStock fields as required
tblStockMovement fields as required
Button(s) to open the frmThePlan to update txtTheAnswer or AnsChkBx as required.
frmThePlan would have:
txtPlanName (This cannot be modified)
txtStockCode (This cannot be modified)
Various others from tblTheStock, or tblStockMovement (This cannot be modified)
sfrm QuestionsAnswers
txtTheQuestions (This cannot be modified)
txtTheAnswer (This can be changed)
AnsChkBx (Y/N/NA) (This can be changed)
My problem is setting up the frmThePlan . I cannot get the sfrm QuestionsAnswers to work. Trying to get:
| The Plan: | PlanName |
| ||
| The Stock | StockName |
| ||
| Various others | tblStockMovement |
| ||
|
|
|
| ||
| Subform |
|
| ||
| txtTheQuestions | txtTheAnswer | AnsChkBx | ||
| Question 1( | This | Y | ||
| Question 2 | that | N | ||
| Question ….. | The other | N/A | ||
Any help would be appreciated.
Thanks
Posted by: robejohg@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar