I have created a database (attached) in which I am having an issue.
In essence there are 4 types of forms
- Switchboard from which to launch actions
- data maintenance (frmAddAngler, frmAddFishType, frmAddPhoto & frmAddVenues)
- view data (frmViewCatches)
- add catch data (frmAddCatch)
I am...
I am trying to set up a database to store and report on a football score predictor game for friends.
In essence each week there will be 6 games for which each participant will predict the outcome (Home win, Away Win or Draw) with 1 point awarded for each correct selection.
Where I am running...
I've done some Googling and search the forums but am drawing a blank or not understanding the proposed solutions correctly.
Problem Statement:
Find the last 6 records for each supplier/item combination from a list of 100's of records.
Data:
ORG
VENDOR_NAME
ITEM
PO_NUM
LINE_NUM
LAST_UPDATE...
I've reached that point where I can no longer think straight about a form issue, despite many searches :banghead:
Here's what I am trying to do:
I have a team working for me who are responsible for taking an action on multiple records once a certain stage has been reached. I've got all the...
I am having a brain block on how to approach a problem I have with Inventory.
I need to be able to migrate an inventory snapshot built from 2 separate stock records which at their highest level (Item/Lot/Qty) will be the same.
My first step is to create a 'matching' inventory table based on...