Solved Stock Transfer Relationship (1 Viewer)
- Thread starter ahmad_rmh
- Start date
From a normalization standpoint it looks good--no huge red flags. So, now to decide if it is right is up to you. Here's a bunch of questions to help you decide :
Does it properly mimic your organization and how it handles stock? Can you put some sample data in it and have it accurately accomplish what you want? Can you get data out of the system in a sensible manner? Did you miss an edge case--sometimes X happens and that means Y should be this, etc?
Does it properly mimic your organization and how it handles stock? Can you put some sample data in it and have it accurately accomplish what you want? Can you get data out of the system in a sensible manner? Did you miss an edge case--sometimes X happens and that means Y should be this, etc?
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 22:29
- Joined
- May 7, 2009
- Messages
- 19,245
will you not also record Who made the Transfer and Who Requested such transfer also the Reason for each transfer?
do you also record the Gatepass for this transfer.
what i am talking here is the Traceability of the item.
do you also record the Gatepass for this transfer.
what i am talking here is the Traceability of the item.
Hi Arnel,
How are you?
The sub form is linked with main form cascading combobox. When i want to view sub form in datasheet view, it requests parameters.
I have attached screenshots.
Kindly suggest solution and codes.
Thanks
How are you?
The sub form is linked with main form cascading combobox. When i want to view sub form in datasheet view, it requests parameters.
I have attached screenshots.
Kindly suggest solution and codes.
Thanks
Attachments
-
Capture.GIF -
Capture1.GIF
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 22:29
- Joined
- May 7, 2009
- Messages
- 19,245
you need to create a Query from your 4 tables.
then select which fields you need to show in the query.
you can use this query to show you the records or
you can create a Form using this query.
then select which fields you need to show in the query.
you can use this query to show you the records or
you can create a Form using this query.
- Local time
- Today, 10:29
- Joined
- Feb 19, 2002
- Messages
- 43,275
There are several problems with the schema.
1. All the PKs are named ID. That just confuses everything.
2. Autonumbers are unique. That means that there is no point in including other columns in the PK definition. The Autonumber all by itself is the PK. If you want a separate unique index on the combination of the two FKs in the junction table, you must use the Indexes dialog. That is the only place you can define a multi-field unique index.
3. The two relationships should be shown with separate tables. Add a second instance of the warehouses table. Access will suffix the second one with _1. That allows you to clearly define the two relationships. It does not duplicate anything.
1. All the PKs are named ID. That just confuses everything.
2. Autonumbers are unique. That means that there is no point in including other columns in the PK definition. The Autonumber all by itself is the PK. If you want a separate unique index on the combination of the two FKs in the junction table, you must use the Indexes dialog. That is the only place you can define a multi-field unique index.
3. The two relationships should be shown with separate tables. Add a second instance of the warehouses table. Access will suffix the second one with _1. That allows you to clearly define the two relationships. It does not duplicate anything.
