New to the app and so far liking a lot of the features, i have been watching a lot of tutorials and it really is easy to sue for most parts.
I am struggling though with how to setup my database’s and fields. probably easier to explain what i am trying to achieve and then work back words.
My end result would be a product list of items ordered by a customer, this should include an image per order and the ability to edit one of the fields.
I could have around 400+ products, all with images and other attributes. Along with this i have over 1000+ customers (potentially).
So first database is Products, in here i have put Product Code, Product Name, Product Image
I then have a second database called Customer Orders, in here my thinking is that it will contain Product Code, Quantity Ordered, Quantity Received (where Quantity received will be the editable field)
How do i link these tables so when i do a repeating group it pulls through the image from the product table.
It is not realistic to have the image on each order as this will make it massive.
(On sql i would have a join on product code and bring the image through)
Will give it a go, usually it is a simple foreign key in the secondary table that joins to the main table. (Which I had thought I had done with productcode in database 1 and productcode in database 2). I assumed I can then retrieve field from both. Like a normal sql query.
