Recent content by iqJafa

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