Search results

Let me preface by saying that my manager is keen on using Access for this project and very much against using Excel other than for inputs/outputs. Below is my thought process for my database. It would be a huge help if you guys could identify any red flags you see with what I am aiming to...

I currently have a table called “Payment History.” Though there are numerous fields, my question only pertains to two particular ones LineID and PoID (representing Line ID and Purchase Order ID respectively). There is a one-to-many relationship between these two fields (i.e. a single purchase...

My question regards 'linking' two tables (i.e. clicking on a value in one table will bring you to that same value in another table). Here is a summary of what I have and what I want to do: Table 1: Purchase Orders -This table gives information about a respective purchase order (PO) with each...

I have two tables: Payments by Month and Payments by Quarter. The 'Payments by Month' Table has fields that indicate how much of a given payment was received in a certain month (i.e. 12 fields). The 'Payments by Quarter' likewise has similar information, however reduced to only quarters (i.e. 4...