Creating a database for clothes which allows 'pairing'

tardypigeon · Newbie Joined: 03 Jun 2012 Posts: 2

Hi there

I've had a good read through the forum but couldn't find anything to help me with my issue, which is that I want to make a database, complete with pictures, of all my clothes. That bit is not really a problem. I can make a really basic database. My problem is that I want to specify a link between various items to suggest those that go together.

So I want the database to have the following attributes: picture of each item, colour, genre (e.g. shirt, trousers, shoes, tie), formality (formal/casual). That bit is all fairly easy to do. What I can't do is pair up various items in such a way that 'Black trousers' could have a relationship to a whole host of other items.

Ideally, I'd like to use it to create a programme or webpage that would help you choose which clothes to wear (for example), so that if you click on 'Bermuda shorts' (and no, I don't own a pair myself) you see a list of pairings so that it would show 'Hawaiian shirt' but not 'Black Tie'.

I realise not all of that is possible in Base, but I wondered if Base could do the, well, basics. Of course, if anyone knows of an alternative way of doing this, I'd be glad to know.

And yes, I do realise this sounds like a very serious case of OCD here, but really it is more of an obsession to prove to myself that such a database is possible.

Thanks for reading,

Tardy.

DonaldEdna · General User Joined: 24 Mar 2012 Posts: 6

Hello,

At first you create a database complete with pictures, of all your clothes, then attributes: picture of each item, colour, genre (e.g. shirt, trousers, shoes, tie), formality (formal/casual).

Thanks
Donal

dacm · Super User Joined: 07 Jan 2010 Posts: 734

tardypigeon · Newbie Joined: 03 Jun 2012 Posts: 2

That's brilliant dacm. So it looks like it'll be fairly tricky. There's one other thing that is probably asking too much of Base, but it seems so open and flexible I think it's worth asking: could I design a form which allows me to form the 'pair' relationship between items that takes the form of two pictures, one of the chosen item and one of another item, with a YES and a NO button. Once I click the YES button, the chosen item would be 'paired' and then a different pic would load to be paired with the chosen pic, and so on.

What I'm really asking is 'Is it possible to simplify the form which creates relations between items to just pictures once the various entries are there?'

Thanks again

Tardy