Search results

Thanks to everyone who responded to this thread. The issue is now solved, Special thanks to @mike60smart who helped me by redesigning the database.

I have re-defined the relationships. But couldn't figure out how data will be mapped between tblcustomers, tblcustomerplatforms and tblplatforms.

Although we haven't encountered any such purachase yet, but hypothetically speaking if we did have, we're going to deal with the customer as another person and another account as if you have two accounts on ebay sharing same address and billing details.

CustomerPLTID: Customer User Name in the relevant platform. CustomerName: Now I have changed this into CustomerFirstName and CustomerLastName as per your suggestion. Also I detailed the address into AddressLine1 and AddressLine2, city and Province. Mobile is now Phone and Mobile.

Hi again, I applied the suggestions to my DB. CustomerUsrName holds what I used to call CustomerName: cutomer ID in the releavant platforn. CustomerName will be the customer real name I haven't deleted the redundant fields in tblCustomers, yet. Just want to make sure I'm on the track. Thanks

I didn't quite understand the point here. So, I should have a separate table for CustomerName and Platform? But what would the PK be here? And what is the FK in Customer's table?

My bad. 1. Delivery I've changed it to Shipping. Data type is a Number which is P&P charge. Delivered is Yes/No field. Now I guess all the three fields: OrderDate, Shipping Date and Delivered don't belong. InvoiceAmount is the subtotal. We'll add shipping charge to it and take away the...

I ditched the platform table and replaced PlatformId with Platform name (Facebook, Instagram, etc). I can confirm that all customers are allowed to use one Platform to make orders. Should any customer chooses to switch platform, his details will change accordingly.

I've just reposted the relationships #17

Thank you. It makes more sense to me now (I think). Now I changed both field names and structure and the relationships. Do they look all right now?

Thank you so much

What does BE stand for?

I don't have any look up field in the tables. However, I have changed the field name into Customer PLTID (Customer Platform ID).

Customer name is actually the customer ID on the platform (Facebook, Instagram, WhatsApp) and the Name is the customer's real

Act I used a combobox where I can choose or enter a new customer on the header of the form. Then I tried to use a list box to be able to select more than one item but it didn't work either. The subform is to enter the invoice details

Hi, So I'm still trying to get this database working. Can anyone help me with the relationships, what have I done wrong cos when I created a form to record new orders with an invoice subform, there seemed no connection between the tables.

Hi, thank you. I have a very basic knowledge of relationships and so far failed to implement any, they didn't do or map anything. I am going to have to study this sample database more and try to create those four tables.

Thank you. As I understood from the search, that I need to create a seperate table for each order. But wouldn't that make hundreds of tables which is opposite to simplicty.

Thank you, I looked at this db in my access but it was depressing, I couldn't understand anything.

Hi everyone, I am a beginner in MS Access and trying to create a database for my sales. What I am trying to do but can't is this: I want to create a table to record my sales, the first field would be the order number; withing each order, there would be one item or more. So in order to overcome...