Search results

Thank you! I think I understand now. So one table would be better for now. Great thoughts Galaxiom, I appreciate it.

Sorry, mi mistake - I already have those two tables (Expenses and Cars). My issue is if it is ok to have one table for exoense attributes where FUEL will be empty for half of items or I have to split this “tblCarExpense” into two - one for FUEL and one for OTHER CAR EXOENSES where field “FUEL...

Hi, I'm thinking about design of my database of expenses. The issue I have is when I put expense related to car, i want to add also info about (other than Autonumber ID and related expense ID): CAR ID Odometer value and in case of Fuel also fueled liters. And that is the problem. Do I have to...

Thank you both! I will do some testing if this works for me (if I will be able to implement it). Much appreciated :)

Hi guys, is it possible and/or optimal from the point of relational database to have in-table relationships? My issue: I have Table called Car Logbook where I put mileages I have traveled. When i travel somewhere I always put total tachometer value (Tachometer End Mileages) and Distance into...

Hi guys, I'm new here and I decided to join your community as I have found a lot of very helpful topics/answers here. I currently decided to move few of my databases to Access from Excel. I resisted for years to do so, totally ignoring Access as one of possibilities for my issues. So now I'm...