Someone Please Help me with this.
Someone Please Help me with this.
Yep got it. Now the table structure. Have you got it
Sent from my iPhone using Tapatalk
Yes, you Sent me this Structure bro.
tblReadings:
ReadingID (Auto)
PumpID (FK) (int)
Reading (long)
Reading Date/Time (Date/Time)
tblPupms
PumpID (Auto)
PumpName (Text)
PumpFuel (FK)
tblFuel
FuelID (Auto)
FuelType (Text)
UnitPrice (Decimle)
Relationships next?
Sent from my iPhone using Tapatalk
Yeah, Relationships
Where to take this Foreign Key from?
tblPumps
PumpID (Auto)
PumpName (Text)
PumpFuel (FK)
Fuelid
Sent from my iPhone using Tapatalk
Relationships Done. Now Working on Queries. I will Definitely let you know if something goes wrong.
What is this for? A form where people input info?
Sent from my iPhone using Tapatalk
Exactly.. There is only One user who is going to Input Data and Make Reports for Each Day's Sales.
Can you zip your current file and post it on here dtoxic I need a closer look
Sent from my iPhone using Tapatalk
Check Private andy49
DB.zip
Here is my File Bro
Test 3.zip
have a look at this.