Is it Possible to make multiple entries for a single key entry?

Greeting of the day,
A tutorial I have seen for giving multiple Image / File type entries,

Is it being possible to do the same for the following structure in where the type is text,

The format goes like this

Date(changetimestamp)
UUID
Shop/person (reference table)
number (reference table)

This is the order I would like to give multiple entries for my entry of Shop/person

(1-4) will be repeated multiple times ( I do not have any fixed Number for this, so I am not able to make the structure for this which should be assigned under the shop/person (where uniqueid(โ€œUUIDโ€) is the column i am using for the shop/person Identification)

1.Product,
2. Number of pieces (Nos)
3.Price,
4.Discount,

where 5 gives the total of all entries
5. Total Amount

Regards.

0 5 105
5 REPLIES 5

A tutorial for adding Multiple images

You left a space between the ] and (

The tutorial seems pretty straightforward, you wonโ€™t find more detailed info here. Follow it. Unless I have understand you wrong

Which โ€œentriesโ€ are you talking about? Multiple images, documents, etc?

Firstly, Thank you for your reply.

Yes I do agree that the tutorial is straightforward,

my query is can I do the same for inputting text.

If so, how can I do it!

this is just title :A tutorial for adding Multiple images

The format goes like this

Date(changetimestamp)
UUID
Shop/person (reference table)
number (reference table)

Can I apply the same for entering multiple data (type of data: text).

This is the order I would like to give multiple entries for my entry of Shop/person

(1-3) will be repeated
1.Product,
2. Number of pieces (Nos)
2.Price,
3.Discount,

where 4 gives the total of all entries
4. Total Amount

Regards.

Respected sir/ maโ€™am,
@Steve @yuvalsh
Can you help me with this problem?
Thank you in advance.

Regards

No, the idea of a key is that its value appears once and only once in the table in that column.

Simple. Donโ€™t use the Person/Shop as the key. What I recommend is to have a dedicated column for the key and use the UNIQUEID() function to randomly assign a unique id used as the row key. Then you can add as many rows as you want for the same Person/Shop - each would have a unique key column value.

Thank you very much for the reply,

this is just title :A tutorial for adding Multiple images

The format goes like this

Date(changetimestamp)
UUID
Shop/person (reference table)
number (reference table)

This is the order I would like to give multiple entries for my entry of Shop/person

(1-3) will be repeated multiple times ( I do not have any fixed Number for this, so I am not able to make the structure for this which should be assigned under the shop/person (where uniqueid(โ€œUUIDโ€) is the column i am using for the shop/person Identification)

1.Product,
2. Number of pieces (Nos)
2.Price,
3.Discount,

where 4 gives the total of all entries
4. Total Amount

Regards.

Top Labels in this Space